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.
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
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 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.NTSB SEA00WA064Accident · No injuriesForeign investigationCessna 208 · Filitheyo, MaldivesNTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB 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…NTSB CHI00WA063Accident · No injuriesForeign investigationBoeing B-707 · Tanzania, SudanNTSB 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.NTSB MIA00WA080Accident · Minor injuriesForeign investigationBeech D18S · Bimini, BahamasNTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB NYC00WA071Accident · 3 fatalForeign investigationRobinson R-44 · Chorley, United KingdomNTSB 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…NTSB 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…NTSB 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…NTSB CHI00IA087Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC9-32 · Milwaukee, WIthe chafing of the internal water heater wire. A factor was the missing ground strap.NTSB 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.NTSB LAX00LA085Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF260 · Napa, CAFuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.NTSB 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…NTSB DCA00WA022Accident · 169 fatalForeign investigationAirbus Industrie A 310 · Abidjan, Côte d’IvoireNTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.NTSB 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.NTSB 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.NTSB FTW00LA077Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Sarita, TXThe failure of the pilot to maintain main rotor rpm, which resulted in a hard landing.NTSB 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.NTSB LAX00LA137Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Oakland, CAThe inadvertent porpoise and improper remedial action of the pilot during the landing attempt.NTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.NTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.NTSB 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…NTSB 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.NTSB FTW00RA076Accident · 5 fatalForeign investigationCessna 404 · Guadalajara, MexicoNTSB 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.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.