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 LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.NTSB ENG07IA030Incident · No injuriesIncident investigationFinal reportLearjet 36 · Bismarck, NDA total loss of engine power during takeoff due to the right engine sustaining a fractured fan blade after the ingestion of a mallard duck. Some liberated fan blade fragments were uncontained, penetrating the nacelle.NTSB CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB SEA07CA143Accident · No injuriesData collectionFinal reportCalstar 1 Eurocopter BO-105S · Concord, CAThe pilot's failure to maintain clearance from an object during hover. Trees were a factor.NTSB NYC07WA129Accident · 1 fatalForeign investigationRobinson R-44 · Kashira, RussiaNTSB LAX07CA187Accident · Serious injuriesData collectionFinal reportAviat Husky A1-B · Winston, MTThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude in a canyon that led to a stall. The pilot's decision to fly along the canyon wall at a low altitude and low energy state was a factor.NTSB DFW07WA133Accident · 1 fatalForeign investigationCessna 172P · Meranges, SpainNTSB DEN07LA098Accident · Serious injuriesLimited investigationFinal reportBoeing 757-251 · Denver, COThe inadvertent encounter with moderate turbulence during the approach which resulted in a serious injury to the flight attendantNTSB NYC07WA142Accident · 4 fatalForeign investigationRobinson R-44 · Teramo, ItalyNTSB NYC07CA139Accident · No injuriesData collectionFinal reportCessna 170A · Smithfield, NCCollapse of the left main landing gear during landing, for undetermined reasons, which resulted in substantial damage during a runway excursion.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB LAX07LA184Accident · No injuriesLimited investigationFinal reportBrook Lancair IV-P · Parowan, UTA loss of engine power due to engine inlet icing. Contributing to the accident was the lack of engine inlet anti-icing capability.NTSB LAX07CA185Accident · Minor injuriesData collectionFinal reportCessna 172S · Wendover, UTThe pilot's failure to maintain directional control during the landing roll.NTSB DFW07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rockport, TXThe pilots improper landing flare which resulted in a hard landing. Contributing factors were the pilot's delayed actions to abort a wheels-up landing.NTSB DFW07CA127Accident · Minor injuriesData collectionFinal reportCessna 182L · Cheneyville, LAThe loss of engine power while climbing due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the soft terrain at the forced landing site.NTSB DFW07CA125Accident · Minor injuriesData collectionFinal reportCessna A188B · Happy, TXAn in-flight fire while maneuvering for an undetermined reason.NTSB ANC07WA041Accident · 1 fatalForeign investigationBell 412SP · Nakatsugawa, JapanNTSB SEA07LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Rosamond, CAThe pilot's failure to abort the takeoff due to lack of airplane climb performance, which resulted in a collision with terrain.NTSB SEA07GA142Accident · 2 fatalFinal reportChristen Industries A-1 · Loa, UTThe pilot's failure to maintain an adequate airspeed during low altitude maneuvering flight that resulted in a stall. The pilot's decision to operate the airplane at a center of gravity beyond the rear limit, the low altitude of the flight, and the high…NTSB LAX07CA183Accident · No injuriesData collectionFinal reportCessna 210F · Denton, MTThe pilot's decision to abort the landing with insufficient runway available to gurantee obstruction clearance.NTSB LAX07CA182Accident · No injuriesData collectionFinal reportCessna 340A · Chandler, AZfuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.NTSB LAX07CA181Accident · No injuriesData collectionFinal reportDutton Air Camper · Atwater, CAa loss of power due to the failure of the number 2 connecting rod.NTSB DFW07CA128Accident · No injuriesData collectionFinal reportDoggett Jack Samson · Conroe, TXThe failure of the main landing gear for undetermined reasons.NTSB DFW07CA126Accident · Minor injuriesData collectionFinal reportGray Jack Tean Rocket F1 · Seabrook, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DEN07WA106Accident · No injuriesForeign investigationGulfstream Aerospace G-V · Zurich, SwitzerlandNTSB DEN07CA097Accident · Minor injuriesData collectionFinal reportStevenson RV-6 · Oakley, KSThe pilot's failure to maintain airspeed during final approach resulting in a inadvertent stall and impact with terrain.NTSB ANC07CA042Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's delay in aborting the landing, which resulted in an in-flight collision with trees.NTSB LAX07WA190Incident · No injuriesForeign investigationBeech 200 · Victoria, AustraliaNTSB SEA07LA140Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Shearer, IDA fracture and separation of the left main landing gear strut during the landing roll due to fatigue.NTSB MIA07CA104Accident · No injuriesData collectionFinal reportCessna 170B · Pahokee, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.NTSB CHI07LA159Accident · No injuriesLimited investigationFinal reportCessna 340A · Middleton, WIFailure of the right main landing gear extension and retraction linkage, which allowed the gear assembly to collapse during landing rollout. An additional cause was the improper adjustment procedure(s) by undetermined mechanic(s). The runway lights struck…NTSB ATL07LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Columbia, SCThe pilot's improper landing flare, resulting in a hard landing.NTSB ANC07LA040Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · McGrath, AKAn undershoot and collision with the runway when the pilot misjudged the distance/altitude during the landing flare/touchdown.NTSB SEA07CA139Accident · No injuriesData collectionFinal reportHughes 369D · Torrance, CAThe pilot's loss of helicopter control while maneuvering at low altitude, which resulted in a hard landing. The wind gusts were a contributing factor.NTSB MIA07CA103Accident · Serious injuriesData collectionFinal reportHughes 269A · Las Piedras, PRThe failure of the non-certificated pilot to maintain a proper rate of descent during the autorotative landing following a reported loss of engine power for undetermined reasons, resulting in a hard landing.NTSB DFW07CA123Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Banquete, TXThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.NTSB SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.NTSB SEA07LA135Accident · 1 fatalLimited investigationFinal reportHughes 369D · Columbus, MTThe fatigue failure of a turbine blade due to a localized over-temperature of the turbine section as result of a non-uniform fuel distribution by the fuel nozzle. Contributing to the accident was the close proximity of a power line support structure which…NTSB SEA07FA134Accident · 1 fatalField investigationFinal reportCessna 185 · Wilbur, WAIn-flight collision with terrain shortly after takeoff for undetermined reasons.NTSB NYC07LA149Accident · No injuriesLimited investigationFinal reportMesserschmitt BO-105 · Isla de Vieques, PRThe mechanic's failure to secure the engine governor locking hardware, which resulted in the right engine losing power.NTSB LAX07LA179Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Napa, CAFailure of the number 5 connecting rod due to oil starvation.NTSB LAX07CA178Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mammoth Lakes, CAthe pilot's failure to ensure that the runway was clear of other aircraft before takeoff.NTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.NTSB CHI07LA157Accident · 1 fatalLimited investigationFinal reportPurvis Rans S6S · Newark, ILThe pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…NTSB CHI07CA158Accident · No injuriesData collectionFinal reportCessna 182S · Cedarburg, WIThe improper landing flare which resulted in the airplane porpoising during the landing and the subsequent overload of the nose gear.NTSB MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.NTSB LAX07CA177Accident · Minor injuriesData collectionFinal reportMD Helicopters 500-E · Yerington, NVThe failure of the student and instructor to maintain an adequate main rotor rpm, and the instructor’s inadequate in-flight supervision while conducting a low-level simulated emergency procedure, which resulted in a hard landing.NTSB LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.