NTSB investigations, 1999, NY
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 1999
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") = 1999 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 IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.NTSB IAD00LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Olean, NYthe loss of engine power from water-contaminated fuel due to the pilot's inadequate preflight inspection.NTSB NYC00LA040Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · Flushing, NYwas the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…NTSB NYC00IA036Incident · No injuriesIncident investigationFinal reportBoeing 767-200 · Jamaica, NYTotal failure of the stabilizer control system for undetermined reasons.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB NYC00FA023Accident · Serious injuriesField investigationFinal reportCessna T303 · Binghampton, NYThe pilot's improper in-flight decision to descend below the decision height without the runway environment in sight, and his failure to execute a missed approach. A factor in the accident was the failed crankshaft.NTSB NYC00LA021Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Westbury, NYthe failure of the operator to ensure the pilot was adequately trained to conduct all inspections required by the flight manual, which resulted in the pilot's inadequate preflight and subsequent failure of the tail rotor pitch change rod. Factors were the…NTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.NTSB NYC99GA234Accident · Serious injuriesFinal reportBell 206L-1 · Randolph, NYThe pilot's failure to maintain visual separation from the wires. A factor was sunglare.NTSB IAD99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.NTSB NYC99LA217Accident · No injuriesLimited investigationFinal reportHughes 269C · Utica, NYThe pilot's failure to maintain control of the helicopter while maneuvering, which resulted in a hard landing. A factor in this accident was the pilot's lack of total experience in helicopters.NTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.NTSB NYC99LA202Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Prattsburg, NYPropeller blade separation, resulting from fatigue cracking initiated by intergranular corrosion. A factor was the lack of propeller blade corrosion inspection requirements.NTSB IAD99LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYwas the student pilot's improper control input and the flight instructor's delayed remedial action.NTSB NYC99LA196Accident · No injuriesLimited investigationFinal reportCessna 172P · Montgomery, NYthe failure of the student pilot to maintain directional control during the touchdown and landing roll.NTSB NYC99LA190Accident · Minor injuriesLimited investigationFinal reportRobinson R-22A · Shirley, NYThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.NTSB IAD99GA056Accident · Minor injuriesFinal reportEurocopter AS-350 · Islip, NYThe pilot's loss of control during hydraulics-off hovering flight and the instructor's inadequate supervision of the maneuver. A factor was the tailwind.NTSB NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.NTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.NTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.NTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB NYC99LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hamburg, NYThe pilot's improper recovery from a bounced landing. A related factor was the lack of experience in make and model.NTSB NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.NTSB IAD99LA048Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Boonville, NYThe pilot's failure to attain takeoff speed and his failure to maintain directional control.NTSB NYC99LA128Accident · Serious injuriesLimited investigationFinal reportCessna T310Q · West Laurens, NYthe pilot's impairment due to hypoxia, which resulted in reduced situational awareness and a power loss due to fuel exhaustion.NTSB NYC99FA126Accident · 2 fatalField investigationFinal reportBeech D50C · Montgomery, NYThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin.NTSB NYC99FA110Accident · Serious injuriesField investigationFinal reportSaab-Scania 340B · Jamaica, NYThe pilot-in-command's failure to perform a missed approach as required by his company procedures. Factors were the pilot-in-command's improper in-flight decisions, the pilot-in-command's failure to comply with FAA regulations and company procedures,…NTSB NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.NTSB NYC99LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Oswego, NYThe pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.NTSB NYC99FA100Accident · 1 fatalField investigationFinal reportStock S-1S · Westtown, NYThe pilot's inability to recover from an intentional stall spin maneuver. A factor in the accident was the change in the airplane's center of gravity which made the airplane more difficult to recover from a spin.NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.NTSB NYC99LA090Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Jefferson, NYthe lack of supervision by the flight instructor which resulted in a low rotor condition and subsequent hard landing.NTSB NYC99LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Ramapo, NYFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor in the accident was the flight instructor's inadequate supervision of the solo cross-country flight.NTSB NYC99LA083Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Orient, NYThe pilot's inadequate compensation for crosswind conditions during takeoff.NTSB IAD99LA035Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Irving, NYwas the pilot's intentional flight into known icing conditions.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB NYC99LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Monticello, NYThe pilot in command's loss of directional control.NTSB NYC99LA235Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · New York, NYInadequate counterbalancing to compensate for the weight of the cargo door.NTSB NYC99LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-24R · Farmingdale, NYThe pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.