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 CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB ATL05CA085Accident · Serious injuriesData collectionFinal reportCanadair CL600 · Augusta, GAThe pilot-in-command's improper use of the flight controls during climb which resulted in the flight attendant injury. A factor was the flight crew failure to follow written procedures during transfer of flight controls.NTSB SEA05LA103Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Emmett, IDThe partial loss of engine power during cruise flight as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a hardened and brittle fuel selector valve O-ring. Factors include no suitable landing area within the…NTSB SEA05LA101Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Driggs, IDThe pilot's failure to compensate for wind conditions, which resulted in a ground loop/swerve during the landing roll. A crosswind was a factor.NTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB MIA05LA106Accident · Minor injuriesLimited investigationFinal reportPitts S1S · Lake Wales, FLImproper maintenance inspection by other maintenance personnel, which resulted in a loose fuel line fitting going undetected, a fuel leak onto exhaust piping, and a fire.NTSB LAX05LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Avalon, CAfuel exhaustion due to the pilot's inadequate preflight and failure to refuel the airplane prior to takeoff.NTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.NTSB CHI05LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mt. Pleasant, MIThe pilot's misjudged distance/speed which led to an overrun and collision with a vehicle. Contributing to the accident was the flight instructor's delayed remedial action in executing a go-around.NTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB ATL05LA084Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82-C · Franklin, GAThe total failure of the left magneto resulting in a partial loss of engine power on initial takeoff climb, forced landing, and in-flight collision with wires and the ground.NTSB MIA05CA109Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing and damage to the airplane.NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…NTSB LAX05CA182Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oxnard, CAthe pilot's failure to maintain an adequate clearance from the building. The pilot's diverted attention was a factor.NTSB DCA05WA067Accident · No injuriesForeign investigationBoeing B-777-232 · London, United KingdomNTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB DFW05LA126Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Ralls, TXThe pilot's failure to maintain clearance from the antenna tower. Contributing factors were the recency of the tower's construction and the lack of obstruction lights on the tower.NTSB DFW05LA125Accident · 2 fatalLimited investigationFinal reportAerostar International S53A · Shreveport, LAThe pilot's failure to maintain clearance from electrical power lines.NTSB DEN05LA081Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · St. George, UTthe pilot's improper autorotation. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN05CA079Accident · No injuriesData collectionFinal reportSchweizer 269C · Pueblo, COthe student pilot's failure to maintain control of the helicopter during the landing. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.NTSB DEN05CA078Accident · No injuriesData collectionFinal reportBell 47G-5A · Brush, COThe pilot's failure to maintain clearance from the truck trailer during takeoff. A factor contributing to this accident was the truck trailer.NTSB CHI05IA116Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Kansas City, MOThe fatigue failure during cruise flight of the fan spinner and forward fan retaining ring due to an interference between the mating parts resulting from the inadequate design by the manufacturer.NTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB CHI05CA118Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Ypsilanti, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. Factors associated with the accident were the crosswind condition and the taxiway sign which was contacted. This case was modified October 12, 2006!!NTSB CHI05CA117Accident · Serious injuriesData collectionFinal reportAviat A-1B · Lodgepole, SDThe poor inflight planning and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the low altitude at which the airplane encoutnered its own wake.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB IAD05IA066Incident · No injuriesIncident investigationFinal reportCessna R182 · West Mifflin, PAThe failure of the landing gear actuator downlock pin due to fatigue, which resulted in the nose landing gear collapsing on landing.NTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.NTSB DFW05CA127Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Rock Springs, TXThe pilot's failure to maintain clearance with a static line. A contributing factor was the low altitude.NTSB SEA05WA111Accident · 2 fatalForeign investigationBeech B55 · Ipil, PhilippinesNTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.NTSB LAX05CA177Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Scottsdale, AZthe student pilot's inadvertent retraction of the landing gear, and the flight instructor's inadequate supervision of the flight.NTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.NTSB DEN05IA076Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Denver, COthe improper use of procedure used by the ground personnel resulting in the right wing of the aircraft colliding with the left wing of another aircraft. A factor in this incident was the failure to maintain clearance by the flight crew of the other aircraft.NTSB ATL05CA083Accident · Minor injuriesData collectionFinal reportRand Robinson Engineering KR-2 · Vienna, GAA loss of engine power due to the owner/pilot mechanic's improper balancing of the modification to engine crankshaft which resulted in an overload failure.NTSB MIA05WA105Accident · 10 fatalForeign investigationBeech 65-A80 · Patagonia, ArgentinaNTSB LAX05LA176Accident · No injuriesLimited investigationFinal reportHughes 369D · Kihei, HIthe partial loss of engine power due to fuel contamination. The fuel contamination was due to the failure of the maintenance personnel to ensure that the helicopter's fuel system had been thoroughly cleaned after a known previous contamination event, and the…NTSB ENG05WA013Incident · No injuriesForeign investigationBoeing 717-200 · Hobart Tasmania, AustraliaNTSB ATL05LA081Accident · 1 fatalLimited investigationFinal reportPaul E. Conner Rotor-EZ · St Elmo, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB ATL05CA080Accident · No injuriesData collectionFinal reportPiper J4E · Akron, ALThe pilot's premature liftoff and his failure to attain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's delay in aborting the takeoff.NTSB NYC05LA085Accident · Minor injuriesLimited investigationFinal reportCessna 525A · Atlantic City, NJThe pilot's improper decision to plan a flight to a runway of insufficient length, his improper in-flight decision to land on that inadequate runway with a tailwind, and his failure to obtain the proper touchdown point. A factor in the accident was the…NTSB MIA05LA104Accident · Minor injuriesLimited investigationFinal reportBritish 167 StrikemasterMK83 · Boca Raton, FLThe delay by the pilot-in-command to abort the takeoff after recognizing excessive elevator control forces for undetermined reasons during the landing roll, resulting in the on-ground collision with a fence.NTSB LAX05WA174Accident · 2 fatalForeign investigationAmerican Champion 7GCAA · Stonefield, AustraliaNTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.