NTSB investigations

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, 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
  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.

NTSB FTW00FA079Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Frisco, TXThe pilot's failure to maintain clearance with trees during an intentional low altitude flight maneuver.Feb 4, 2000 · N6506J · DestroyedNTSB SEA00WA064Accident · No injuriesForeign investigationCessna 208 · Filitheyo, MaldivesFeb 3, 2000 · 8QHIF · Substantial damageNTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.Feb 3, 2000 · N397US · No damageNTSB DEN00LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe student pilot's excessive remedial action (banking to realign the airplane with the runway). Factors were the student pilot flaring the airplane prematurely and failing to maintain directional control, and the flight instructor's inadequate supervision of…Feb 3, 2000 · N8240U · Substantial damageNTSB CHI00WA063Accident · No injuriesForeign investigationBoeing B-707 · Tanzania, SudanFeb 3, 2000 · STAPY · Substantial damageNTSB CHI00LA068Accident · No injuriesLimited investigationFinal reportBeech A23 · Knox, INthe instructor pilot not performing remedial action on the student's right drift during the flare. Factors were the student not maintaining directional control, the student not maintaining proper centerline alignment, and the snowbank.Feb 3, 2000 · N1489L · Substantial damageNTSB MIA00WA080Accident · Minor injuriesForeign investigationBeech D18S · Bimini, BahamasFeb 2, 2000 · N122V · Substantial damageNTSB LAX00LA087Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brawley, CAFailure of the engine due to improper installation of the intake and exhaust push rods (components were switched) by unknown maintenance personnel.Feb 2, 2000 · N23043 · DestroyedNTSB LAX00LA086Accident · No injuriesLimited investigationFinal reportRobinson R44 · Palo Alto, CAThe pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…Feb 2, 2000 · N999EV · Substantial damageNTSB LAX00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Barbara, CAThe dual student's loss of directional control and the flight instructor's inadequate supervision of the flight.Feb 2, 2000 · N32258 · Substantial damageNTSB ANC00LA023Accident · No injuriesLimited investigationFinal reportStirling AIR CAM · Fairbanks, AKThe pilot's improper compensation for wind conditions during the single-engine landing. Factors associated with this accident were the pilot's intentional shut down of the left engine, the right crosswind, the icy runway, and the snow berms on the edge of the…Feb 2, 2000 · N6381V · Substantial damageNTSB NYC00WA071Accident · 3 fatalForeign investigationRobinson R-44 · Chorley, United KingdomFeb 1, 2000 · GTLME · Substantial damageNTSB DCA00MA023Accident · 88 fatalClass 1 · MajorFinal reportDouglas MD-83 · Port Hueneme, CAA loss of airplane pitch control resulting from the in-flight failure of the horizontal stabilizer trim system jackscrew assembly's acme nut threads. The thread failure was caused by excessive wear resulting from Alaska Airlines' insufficient lubrication of…Feb 1, 2000 · N963AS · DestroyedNTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…Jan 31, 2000 · N3433T · DestroyedNTSB MIA00LA079Accident · No injuriesLimited investigationFinal reportBeech D50E · Myrtle Beach, SCThe on-ground fire caused by fuel flowing out the fuel vent and near the exhaust of the left engine resulting in the on-ground fire and substantial damage to the airplane. A finding in the investigation was that all four fuel tanks had been filled before the…Jan 31, 2000 · N14VU · Substantial damageNTSB CHI00IA087Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC9-32 · Milwaukee, WIthe chafing of the internal water heater wire. A factor was the missing ground strap.Jan 31, 2000 · N203ME · Minor damageNTSB LAX00LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Hana, Maui, HIThe student's failure to maintain directional control after encountering a tail rotor vortex ring state induced right yaw.Jan 30, 2000 · N62DF · Substantial damageNTSB LAX00LA085Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF260 · Napa, CAFuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.Jan 30, 2000 · N65FD · Substantial damageNTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…Jan 30, 2000 · N25573 · Substantial damageNTSB DCA00WA022Accident · 169 fatalForeign investigationAirbus Industrie A 310 · Abidjan, Côte d’IvoireJan 30, 2000 · 5YBEN · DestroyedNTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.Jan 29, 2000 · N7854E · Substantial damageNTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.Jan 29, 2000 · N94999 · Substantial damageNTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.Jan 29, 2000 · N8281F · Substantial damageNTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…Jan 29, 2000 · N245DH · Substantial damageNTSB DEN00LA045Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mt Pleasant, UTFailure of the main rotor mast due to fatigue that resulted from inadequate quality assurance during the manufacturing process.Jan 29, 2000 · N212HQ · Substantial damageNTSB MIA00LA077Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · W. Columbia, SCThe inadequate wording of the NOTAM for failure to identify that the usable width of the runway was reduced and the inadequate snow removal by airport personnel for failure to remove the snow from the runway resulting in the on-ground collision with a snow…Jan 28, 2000 · N42Y · Substantial damageNTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.Jan 27, 2000 · N87338 · DestroyedNTSB MIA00LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Statesboro, GAThe partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.Jan 27, 2000 · N11567 · Substantial damageNTSB FTW00LA084Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Dallas, TXThe diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.Jan 27, 2000 · N900WJ · Substantial damageNTSB FTW00LA077Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Sarita, TXThe failure of the pilot to maintain main rotor rpm, which resulted in a hard landing.Jan 27, 2000 · N2330F · Substantial damageNTSB MIA00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ocean Reef Club, FLThe failure of the pilot to maintain directional control of the airplane while taxiing after landing resulting in the on-ground collision with high vegetation.Jan 26, 2000 · N9578C · Substantial damageNTSB LAX00LA137Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Oakland, CAThe inadvertent porpoise and improper remedial action of the pilot during the landing attempt.Jan 26, 2000 · N228ER · Substantial damageNTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.Jan 26, 2000 · N68024 · Substantial damageNTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.Jan 26, 2000 · N7VS · Substantial damageNTSB ANC00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ekuk, AKThe pilot's selection of an unsuitable runway for landing. Factors associated with the accident were the inadequate runway maintenance by the runway maintenance personnel, snow berms, and insufficient runway condition information disseminated by the company…Jan 26, 2000 · N8004N · Substantial damageNTSB MIA00LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, GAThe pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.Jan 25, 2000 · N2469E · Substantial damageNTSB FTW00RA076Accident · 5 fatalForeign investigationCessna 404 · Guadalajara, MexicoJan 25, 2000 · CAA91NTSB FTW00LA074Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rayville, LAThe loss of engine power due to a crack in the #6 cylinder. A factor was the lack of suitable terrain for the forced landing.Jan 25, 2000 · N91968 · Substantial damageNTSB 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.Jan 24, 2000 · N251BD · DestroyedNTSB SEA00WA042Accident · No injuriesForeign investigationCessna 172M · Squamish, CanadaJan 23, 2000 · N1673V · Substantial damageNTSB 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…Jan 23, 2000 · N5801X · Substantial damageNTSB 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…Jan 23, 2000 · N3814P · Substantial damageNTSB MIA00WA073Accident · 7 fatalForeign investigationCessna 207 · Las Terrenas, Dominican RepublicJan 22, 2000 · HI528 · DestroyedNTSB 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…Jan 22, 2000 · N663C · Substantial damageNTSB 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.Jan 22, 2000 · N751JR · Substantial damageNTSB LAX00LA079Accident · No injuriesLimited investigationFinal reportRobinson R22B · Piru, CAFailure of the pilot to maintain control after encountering a dynamic rollover.Jan 22, 2000 · N4072T · Substantial damageNTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.Jan 22, 2000 · N1290C · Substantial damageNTSB 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…Jan 22, 2000 · N386TM · DestroyedNTSB 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).Jan 22, 2000 · N4047C · Substantial damageNTSB 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.Jan 21, 2000 · N223KT · Substantial damage