NTSB investigations, 2000
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, newest first
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\") = 2000 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") = 2000 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 DCA00WA068Accident · Minor injuriesForeign investigationAirbus A310-304 · Vienna, AustriaNTSB ANC00LA086Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotlik, AKThe pilot's inadequate flare during landing.NTSB SEA00LA131Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Burley, IDImproper airstrip operations by ground personnel, and the pilot's failure to visually detect a vehicle on the airstrip in time to avoid a collision. Factors included a vehicle on the airstrip, tailwind conditions, and high density altitude conditions.NTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…NTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.NTSB NYC00LA195Accident · No injuriesLimited investigationFinal reportFairchild M-62 · Grafton, OHThe pilot's failure to maintain control of the airplane while taking off.NTSB NYC00LA191Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Harpswell, METhe pilot-in-command's improper in-flight decision to maneuver at a low airspeed with a left-quartering tailwind which resulted in a loss of tailrotor effectiveness.NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB FTW00FA201Accident · 1 fatalField investigationFinal reportCessna T210J · Athens, TXthe pilot's inadvertent stall during initial takeoff climb.NTSB ANC00IA088Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKAn inoperative traffic alert and collision avoidance system (TCAS).NTSB SEA00WA130Accident · 4 fatalForeign investigationPiper PA-24-260 · Chilko Lake, CanadaNTSB SEA00LA128Accident · No injuriesLimited investigationFinal reportKeith Kinden Rebel · Libby, MTAn improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.NTSB MIA00LA215Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCA loss of engine power due to failure of the No. 4 cylinder connecting rod during the first flight following engine overhaul for undetermined reasons. Contributing to the accident was unsuitable terrain.NTSB MIA00LA212Accident · No injuriesLimited investigationFinal reportCessna 560 XL · Nashville, TNthe flight crew's failure to activate the normal brake system, and failure to follow published aircraft procedures/directives for a hard brake or no braking condition and use the emergency brake system after recognizing a normal brake system failure, which…NTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.NTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.NTSB CHI00LA210Accident · No injuriesLimited investigationFinal reportGrumman G164 · Mcville, NDthe pilot's failure to maintain clearance with the power lines. A factor associated with the accident was the power line.NTSB CHI00LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Washington, KSthe failure of the number-two connecting rod bearing and the unsuitable terrain for landing encountered by the pilot during the forced landing. A factor to the accident was the rough/uneven field.NTSB CHI00LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Topeka, KSthe restricted fuel line, and the pilot not attaining proper runway alignment during the forced landing. Factors were the low altitude at which the engine failure occurred, and the landing gear overload.NTSB NYC00LA194Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, OHThe pilot's improper decision to abort the takeoff. A factor in this accident was the dark night conditions.NTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB MIA00LA210Accident · Minor injuriesLimited investigationFinal reportJames Browning Midget MUSTANG-I · Waycross, GAthe pilot's failure to maintain control during initial climb that resulted in the aircraft colliding with the ground and incurring damage. A factor in the accident was the pilot's diverted attention, when he inadvertently knocked the spectacles off his face…NTSB LAX00LA257Accident · Minor injuriesLimited investigationFinal reportInteravia E-3 · Watsonville, CAthe total loss of engine power due to the pilot's inaccurate fuel consumption calculations, which resulted in fuel exhaustion.NTSB FTW00RA196Accident · 19 fatalForeign investigationBritish Aerospace Jetstream 3201 · Chulum Juarez, MexicoNTSB FTW00LA199Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Chase, LAThe failure of the pilot to maintain clearance with the deer stand. Factors were the chemical covering the windshield and the glare from the setting sun.NTSB DCA00WA067Accident · 13 fatalForeign investigationCurtis-Wright C-46 · Villavicencio, ColombiaNTSB CHI00LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Cloud, MNdirectional control not being maintained by the pilot during landing rollout.NTSB ANC00LA084Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was rough/uneven terrain.NTSB SEA00FA132Accident · 3 fatalField investigationFinal reportCessna 180F · Gold Bar, WAThe non-instrument rated pilot's attempted VFR flight in instrument meteorological conditions. Contributing factors were mountainous terrain and cloud, low ceiling and obscuration conditions.NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB NYC00LA192Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Westminster, MDthe delayed corrective action by the flight instructor. Factors were the failure of the private pilot to maintain directional control, his failure to use the brakes, and the lack of brakes on the right side for the flight instructor.NTSB NYC00LA188Accident · No injuriesLimited investigationFinal reportCessna 182S · White Plains, NYThe student pilot's failure to recover from a bounced landing and her failure to perform a go-around.NTSB MIA00WA209Accident · Serious injuriesForeign investigationPiper PA32-300 · Staniel Cay, BahamasNTSB MIA00FA208Accident · 1 fatalField investigationFinal reportCessna 402C · Vieques, PRThe airplanes entry into an uncontrolled descent for undetermined reasons from which it crashed into the ocean.NTSB LAX00LA256Accident · No injuriesLimited investigationFinal reportCessna 172 · Chandler, AZfailure of the pilot-in-command to adequately compensate for a crosswind condition and maintain directional control during the landing roll, resulting in the airplane departing the runway and colliding with a sign.NTSB LAX00LA255Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Minden, NVfailure of the pilot to compensate for a sudden wind shift resulting in a loss of directional control and collision with high vegetation.NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB IAD00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dansville, NYthe loss of engine power during take-off for undetermined reasons.NTSB IAD00LA058Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Annapolis, MDThe pilot's failure to attain the proper touchdown point, and his failure to perform a go-around.NTSB IAD00LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172G · North Elba, NYthe pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.NTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…NTSB FTW00LA203Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Pine Bluff, ARthe pilot's misjudged flare, which resulted in a hard landing. A contributing factor was the pilot's lack of total experience in the make and model of airplane.NTSB FTW00LA200Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Moscow, TXthe failure of the power output reduction gear to the propeller. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Leonard, TXThe inadvertent stall. A factor was the improperly positioned fuel selector.NTSB DEN00LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Erie, COAircraft control was not possible by the flight instructor due to the inadequate maintenance adjustment of the tail wheel steering system by maintenance personnel. Factors were the inadequate aircraft preflight by the second pilot who was receiving a…NTSB DEN00LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Montrose, COAn inadvertent stall/mush. Factors were high density altitude, weight and balance exceeded, and pilot fatigue.NTSB DEN00FA127Accident · 4 fatalField investigationFinal reportCessna 195 · Aspen, COthe pilot's poor in-flight decision to fly up a valley with rapidly rising terrain, which resulted in the airplane colliding with the terrain due to its climb performance being exceeded. A contributing factors was the high, rapidly rising, mountainous terrain.NTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…NTSB CHI00FA185Accident · 3 fatalField investigationFinal reportPiper PA-30 · Duluth, MNloss of control in flight for undetermined reason(s).