NTSB investigations, 2000
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA00FA039Accident · 2 fatalField investigationFinal reportMooney M20K · Pendleton, ORThe pilot's failure to adequately remove ice and snow from the airplane. A contributing factor was the pilot's inability to maintain control during climb due to degradation of the airplane's aerodynamic performance.NTSB SEA00WA042Accident · No injuriesForeign investigationCessna 172M · Squamish, CanadaNTSB LAX00LA080Accident · No injuriesLimited investigationFinal reportCessna 310F · Boulder City, NVThe dual student's improper use of the throttles; the flight instructor's inadequate supervision; and the delayed remedial action by the flight instructor. Factors in the accident were the directional control and proper alignment not maintained by the dual…NTSB CHI00LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, INthe pilot's disregard of the unsafe runway condition, his decision to operate the airplane on unsuitable terrain, and the failure to maintain runway centerline alignment which resulted in the landing gear contacting deeper snow. Factors associated with the…NTSB MIA00WA073Accident · 7 fatalForeign investigationCessna 207 · Las Terrenas, Dominican RepublicNTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…NTSB LAX00LA082Accident · No injuriesLimited investigationFinal reportMince Jurka MJ77 · Rio Vista, CAThe loss of engine power during cruise flight for unknown reasons resulting in a forced landing in a plowed field.NTSB LAX00LA079Accident · No injuriesLimited investigationFinal reportRobinson R22B · Piru, CAFailure of the pilot to maintain control after encountering a dynamic rollover.NTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.NTSB FTW00FA070Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-26A · San Antonio, TXthe pilot's failure to maintain the minimum controllable airspeed following a loss of engine power during the initial takeoff climb. Contributing factors to the accident were both pilot's lack of total experience in the make and model of the accident airplane…NTSB CHI00LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · East Troy, WIThe proper alignment not being maintained by the dual student during an attempted running takeoff and the inadequate supervision of the pilot-in-command (CFI).NTSB NYC00LA069Accident · No injuriesLimited investigationFinal reportMooney M20M · Montpelier, VTA blocked crankcase breather line due to ice and improper maintenance which resulted in further restricting the line. A factor in this accident was the below freezing outside air temperature.NTSB LAX00LA078Accident · Minor injuriesLimited investigationFinal reportMyers Q-2 · Compton, CAFailure of the pilot to maintain directional control of the airplane during the takeoff roll.NTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.NTSB FTW00FA072Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Mexia, TXThe pilot's failure to maintain airspeed while maneuvering in the traffic pattern, which resulted in a stall/spin. Factors were the partial failure of the landing gear indication system and the pilot's diverted attention.NTSB CHI00IA062Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · Milwaukee, WIthe hold-short clearance not being followed by the flightcrew, which resulted in a near collision with the departing Boeing 727-200.NTSB MIA00TA070Accident · Minor injuriesFinal reportBell UH-1H · Fort Myers, FLA total loss of engine power due to turbine wheel fracture resulting from fatigue for undetermined reasons that resulted in an autorotation to unsuitable terrain and hard touchdown and rollover.NTSB IAD00LA017Accident · No injuriesLimited investigationFinal reportCessna T310R · Plainville, CTThe pilot's improper decision to attempt to close the pilot's door during the takeoff roll, which delayed the aborted takeoff and resulted in the overrun. A factor in the accident was the snow-covered runway.NTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.NTSB CHI00LA059Accident · No injuriesLimited investigationFinal reportCessna 208B · Warsaw, INthe misjudged unsafe/hazardous condition by the pilot. Factors to the accident were the precautionary landing being performed by the pilot and the snow covered runway. Additional factors were the dark night, the snowing weather condition, the airport…NTSB MIA00LA072Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Palmetto, FLFailure for undetermined reasons of the right main landing gear strut during landing resulting in collapse of the right main landing gear.NTSB LAX00LA076Accident · Minor injuriesLimited investigationFinal reportBell OH-58C · Brawley, CAThe fuel system contamination that resulted in a loss of engine power during aerial application and a subsequent collision with the ground.NTSB FTW00LA068Accident · No injuriesLimited investigationFinal reportMooney M20K · Tyler, TXThe failure of the crankshaft drive gear as a result of fatigue, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Tooele, UTThe pilot's failure to correct the descent, and his failure to maintain a visual lookout. Factors were the pilot's improper weather evaluation, his lack of recent experience in type of operation, his inadvertent encounter with instrument meteorological…NTSB SEA00FA038Accident · No injuriesField investigationFinal reportHughes 269C · Sherwood, ORThe pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.NTSB NYC00FA068Accident · 1 fatalField investigationFinal reportCessna 195 · Willard, KYThe pilot's continued VFR flight into IMC conditions. Factors were the pilot's inadequate preflight planning and snow showers.NTSB NYC00FA067Accident · 4 fatalField investigationFinal reportBeech C-90 · Somerset, KYthe failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…NTSB CHI00LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Stanley, NDthe pilot's improperly performed flare.NTSB FTW00LA066Accident · No injuriesLimited investigationFinal reportCessna 340A · Brownsville, TXThe hard landing of the aircraft resulting from the pilot's excessive rate of descent on the VFR approach. A factor was the loss of right engine power for an undetermined reason.NTSB CHI00LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Liberal, KSthe pilot not maintaining proper glidepath on the ILS approach, the pilot's improper decision to continue the approach below the glidepath, and the pilot's failure to perform a missed approach. Factors relating to the accident were the low ceiling and…NTSB MIA00LA068Accident · No injuriesLimited investigationFinal reportDana A. Moore Danamite · Smyrna, TNthe pilot's excessive taxiing speed and failure to maintain adequate clearance from objects, resulting in the gyroplane's main rotor colliding with a fence and subsequent damage to the aircraft.NTSB MIA00FA069Accident · 1 fatalField investigationFinal reportBeech P-35 · Rogersville, TNthe pilot's improper in-flight planning/decision and continued visual flight into instrument meteorological conditions (IMC) that resulted in an in-flight collision with terrain and subsequent damage to the aircraft.NTSB LAX00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kernville, CAFuel exhaustion due to the pilot's in-flight decision to not refuel the airplane at an en route stop as planned.NTSB FTW00RA064Accident · 4 fatalForeign investigationLet 410 UVP-E · Pavas, Costa RicaNTSB IAD00RA018Accident · 5 fatalForeign investigationLockheed C-130B · Chimore, BoliviaNTSB FTW00TA065Accident · No injuriesFinal reportCessna 150F · Livingston, TXThe total loss of engine power resulting from an exhaust valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00FA063Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, ARthe pilot's failure to maintain aircraft control.NTSB DEN00FA044Accident · 1 fatalField investigationFinal reportPilatus PC-7 · Broomfield, COThe pilot's loss of aircraft control while performing low level aerobatics at an altitude insufficient to make a safe recovery.NTSB CHI00WA120Accident · Minor injuriesForeign investigationAgusta 109E · Romey Marsh, United KingdomNTSB DEN00LA043Accident · No injuriesLimited investigationFinal reportBeech K35 · Fillmore, UTThe pilot's improper use of elevator trim, resulting in his failure to obtain sufficient takeoff airspeed and subsequent inadvertent stall/mush. A Factor was his failure to follow the preflight checklist.NTSB LAX00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Las Vegas, NVEncounter with Clear Air Turbulence. Poor communication between the captain and flight attendants as to the urgency for the flight attendants to take their seats was a contributing factor.NTSB LAX00GA073Accident · 2 fatalFinal reportArrow OH-58A · Crows Landing, CAThe failure of the pilot to maintain altitude and clearance from terrain during a turn to reverse direction after encountering instrument meteorological conditions. A factor in the accident was the pilot's failure to obtain a full weather briefing before…NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.NTSB NYC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Bradford, PAThe pilot's inadequate ice/frost removal from the aircraft.NTSB LAX00LA074Accident · No injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZthe manufacturer representative's improper reinstallation of the crankshaft counterweight snap rings which subsequently separated, allowing the crankshaft counterweight to contact the crankshaft resulting in a total power loss of engine power.NTSB DEN00TA042Accident · Serious injuriesFinal reportBell OH-58C · Lindrith, NMLoss of tail rotor effectiveness while maneuvering. A factor was the high density altitude.NTSB NYC00FA064Accident · 2 fatalField investigationFinal reportAerostar 601P · Coatesville, PAThe pilot's failure to follow the published instrument approach procedure, and his failure to establish a climb after passing the missed approach point.NTSB MIA00FA066Accident · 1 fatalField investigationFinal reportMooney M20M · Mount Pleasant, SCThe pilot's failure to maintain airspeed (VSO) while maneuv ering on a night instrument approach in instrument conditions. This resulted in an inadvertent in-flight loss of control (stall/spin), and subsequent in-flight collision with a swamp. Contributing to…NTSB FTW00LA061Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sherman, TXA jammed carburetor needle which resulted in fuel starvation and the subsequent hard forced landing after takeoff. Contributing factors were the fence, trees, and pilot's maneuver to avoid these objects.NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.