NTSB investigations, 1990, NY
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 8 |
|---|---|
| 1963 | 2 |
| 1964 | 162 |
| 1965 | 197 |
| 1966 | 215 |
| 1967 | 226 |
| 1968 | 181 |
| 1969 | 172 |
| 1970 | 170 |
| 1971 | 164 |
| 1972 | 161 |
| 1973 | 124 |
| 1974 | 167 |
| 1975 | 121 |
| 1976 | 146 |
| 1977 | 152 |
| 1978 | 131 |
| 1979 | 119 |
| 1980 | 101 |
| 1981 | 100 |
| 1982 | 91 |
| 1983 | 95 |
| 1984 | 76 |
| 1985 | 84 |
| 1986 | 71 |
| 1987 | 70 |
| 1988 | 68 |
| 1989 | 64 |
| 1990 | 63 |
| 1991 | 58 |
| 1992 | 36 |
| 1993 | 49 |
| 1994 | 52 |
| 1995 | 58 |
| 1996 | 48 |
| 1997 | 36 |
| 1998 | 42 |
| 1999 | 41 |
| 2000 | 45 |
| 2001 | 42 |
| 2002 | 32 |
| 2003 | 46 |
| 2004 | 32 |
| 2005 | 43 |
| 2006 | 24 |
| 2007 | 43 |
| 2008 | 30 |
| 2009 | 32 |
| 2010 | 49 |
| 2011 | 37 |
| 2012 | 37 |
| 2013 | 28 |
| 2014 | 28 |
| 2015 | 34 |
| 2016 | 33 |
| 2017 | 28 |
| 2018 | 37 |
| 2019 | 19 |
| 2020 | 25 |
| 2021 | 24 |
| 2022 | 27 |
| 2023 | 28 |
| 2024 | 30 |
| 2025 | 16 |
| 2026 | 14 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1990
AND c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1990 AND c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC91IA053Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Elbridge, NYThe failure of the pilot to conduct a proper preflight inspection of the fuel tanks, and a misreading fuel gauge which resulted in a double power loss.NTSB NYC91LA050Accident · No injuriesLimited investigationFinal reportCessna 210 · Warwick, NYA power failure for undetermined reasons, resulting in a forced landing in unsuitable terrain.NTSB NYC91FA042Accident · 2 fatalField investigationFinal reportBeech A24R · Owls Head, NYThe pilot's continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness, adverse weather conditions, and mountainous terrain.NTSB NYC91DFA01Accident · No injuriesFinal reportLowe/Law Glasair SH-3 · Kingston, NYA hard landing that collapsed the left main gear due to overload failure of the trunion.NTSB NYC91LA022Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sherburne, NYThe pilot failed to maintain adequate altitude to outclimb surrounding terrain.NTSB NYC91LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · West Nyack, NYThe improper use of carburetor heat control, which resulted in a loss of engine power and subsequent emergency forced landing and collision with a fence. A factor to the accident was weather conditions suitable to formation of carburetor icing.NTSB NYC91LA013Accident · Minor injuriesLimited investigationFinal reportPorterfield Porterfield FP65 · Moravia, NYPower loss after takeoff due to a partially clogged fuel line between the fuel tank and the gascolator. Contributing to the accident was unsuitable terrain under the airplane when power loss occurred.NTSB NYC91LA002Accident · 2 fatalLimited investigationFinal reportForney 415D · Morrisville, NYThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB NYC90DHM26Accident · No injuriesFinal reportPalen Sopwith Dolphin · Reinbeck, NYUndetermined engine failure during low altitude operations.NTSB NYC90LA224Accident · Minor injuriesLimited investigationFinal reportRockwell 690B · North Castle, NYThe pilot's improper aircraft preflight (fuel cap not properly secured) which resulted in fuel siphoning and fuel exhaustion.NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB NYC90IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · New York City, NYThe exhaust pipe fire in the APU which resulted in an unauthorized evacuation of the airplane by the passengers.NTSB NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.NTSB NYC90FA215Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Montgomery, NYAn inadequate preflight by the pilot which resulted in a power loss due to fuel exhaustion.NTSB NYC90LA209Accident · 1 fatalLimited investigationFinal reportCessna 172L · Montauk, NYPilot failed to attain airspeed during a go around, resulting in the airplane stalling at a low altitude. Contributing factor was the pilot's attention was diverted to airport maintenance personnel working near the approach end of the runway.NTSB NYC90LA206Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Palmyra, NYPilot's failure to maintain airspeed during approach resulting in the airplane stalling and descending uncontrolled to ground impact.NTSB NYC90DFJ04Accident · No injuriesFinal reportSchweizer Grumman G-164A · Wayland, NYA cracked engine cylinder assembly, which resulted in loss of engine power.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.NTSB NYC90LA194Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Burdett, NYThe pilot did not properly compensate for the cross wind and failed to maintain directional control during takeoff.NTSB NYC90FA192Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Saltaire, NYThe pilot misjudged his altitude.NTSB NYC89LA220Accident · No injuriesLimited investigationFinal reportMicalizio BD-5 · Montgomery, NYThe pilot's failure to maintain control of the homebuilt airplane while performing initial high-speed taxi tests. The pilot's lack of flight experience in the accident make and model airplane was a related factor.NTSB NYC90LA185Accident · No injuriesLimited investigationFinal reportCessna 140 · Middlesex, NYThe student pilot's failure to execute a go-around. Factors which contributed to the accident was his misjudgement of speed and distance which resulted in overshooting the landing.NTSB NYC90LA221Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Binghamton, NYThe pilot's failure to maintain control of the balloon during touchdown resulting in the basket of the balloon tipping. Factors to the accident were the slope of the terrain and the wind.NTSB NYC90LA177Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Shirley, NYImproper use of the flight controls by the student pilot.NTSB NYC90IA178Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-7-102 · New York, NYThe flight crew's failure to folllow the landing gear emergency checklist. Factors which contributed to the incident were: a jammed nose landing gear due to the installation of a bogus part by unknown person(s) and a dirty gear viewing window.NTSB NYC90LA175Accident · No injuriesLimited investigationFinal reportCessna 172 · Edinburg, NYThe pilot did not maintain flying speed, the airplane stalled and descended into trees, at the departure end of the runway.NTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.NTSB NYC90LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, NYThe failure of the pilot to maintain directional control during a rejected landing. Factors related to the accident were: improper use of the flight controls by the pilot, a variable wind, and lack of expereince in type of airplane.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB NYC90LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Shirley, NYThe pilot's lack of qualifications, the improper use of flight controls, the second pilot's lack of qualifications, and his decision to simulate the engine failure.NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB NYC90LA147Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bedford, NYThe failure of the pilot to monitor the fuel gauges and fuel starvation. A factor related to the accident was the failure of maintenance personnel to detect the bent condition of the rear engine tank fuel selector control cable.NTSB NYC90LA142Accident · 1 fatalLimited investigationFinal reportNorth American AT-6 · Buffalo, NYLoss of control in flight due to physical impairment. Factors related to the accident were: the pilots use of an over the counter antihistamine.NTSB NYC90LA132Accident · No injuriesLimited investigationFinal reportBoeing 747-230 · Jamaica, NYThe Boeing 747 captain misjudged clearance between his aircraft and the fokker f.28. A factor related to the accident was: self-induced pressure of the Boeing 747 captain.NTSB NYC90FA129Accident · 2 fatalField investigationFinal reportCessna 337G · Harrison, NYThe pilot's decision to continue VFR flight into IMC and his subsequent loss of control of the airplane. The weather conditions and the pilot's lack of instrument flight experience were factors in the accident.NTSB NYC90LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marcellus, NYFailure of the pilot-in-command to maintain airspeed after takeoff. A contributing factor was the the upslope gradient of the runway.NTSB NYC90LA126Accident · Serious injuriesLimited investigationFinal reportBarnes Firefly 8B · Cazenovia, NYThe passengers failure to comply with the pilots instructions after a hard landing was made.NTSB NYC90LA116Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Athens, NYInflight loss of control due to loss of airspeed and subsequent stall when the pilot's seat back failed and the pilot hung onto the control wheel, resulting in an excessive nose high attitude.NTSB NYC90LA115Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Wallkill, NYThe pilot's failue to maintain flying speed which resulted in a stall. A factor was the pilot's diversion of attention.NTSB NYC90LA114Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider Lsif Sailplane · Mayville, NYJammed flight controls in flight due to a bent aileron push-rod.NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.NTSB NYC90DFG03Accident · No injuriesFinal reportContinental Copters MK15A · King Ferry, NYThe pilot's failure to maintain adequate clearance from power lines during this approach to landing.NTSB NYC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, NYThe pilot's poor judgement in attempting to land the airplane under the existing wind conditions.NTSB NYC90LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Granville, NYThe improper recovery from a bounced landing which resulted in loss of control and collision with a ditch.NTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).NTSB NYC90DHJ01Accident · 1 fatalFinal reportToussaint/Quad City Challenger II · East Moriches, NYFailure of the unlicensed pilot to maintain airspeed on final approach, which resulted in a stall and collision with the ground. Factors related to the accident were: the pilot's lack of flight training, experience, and qualification.NTSB NYC90FA104Accident · No injuriesField investigationFinal reportShort Brothers SD3-60-200 · Jamaica, NYPilot factor in that the pilot taxied into a hold position that was too close to a departing B-747, which resulted in the a/c being blown into a blast fence. Contributing was the lack of available information from the aircraft manufacturer which would have…NTSB NYC90LA091Accident · No injuriesLimited investigationFinal reportCessna O337F · Brant, NYThe pilot's premature rotation and failure to obtain airspeed.NTSB NYC90LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Blossvale, NYFailure of the pilot to maintain directional control during landing. Factors related to the accident were: a gusty quartering tailwind.