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 LAX00LA304Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Olancha, CAThe pilot's inadequate preflight planning and fuel consumption calculations, which resulted in fuel exhaustion and a loss of engine power.NTSB LAX00LA303Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reno, NVThe fatigue failure and separation of the right main landing gear.NTSB LAX00FA302Accident · 1 fatalField investigationFinal reportPiper PA-24 · Independence, CAThe pilot's failure to maintain terrain clearance. Factors included night conditions, cockpit lighting, which compromised the pilot's night vision, and drug impairment.NTSB FTW00LA234Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot's failure to maintain aircraft control. A factor was the crosswind.NTSB DEN00LA154Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Ogden, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were a tail wind, inadequate weather evaluation by the pilot, and lack of experience in make and model.NTSB CHI00LA258Accident · No injuriesLimited investigationFinal reportBeech K35 · Holland, MIthe misjudged glidepath by the pilot. Factors to the accident were the loose throttle cable due to improper installation by maintenance personnel, and the intentional engine shutdown during the precautionary landing by the pilot.NTSB CHI00FA244Accident · No injuriesField investigationFinal reportBoeing 727-264 · Chicago, ILthe fractured tow bar and the inadequate weld of the tow bar by an unknown person.NTSB SEA00WA163Accident · 2 fatalForeign investigationCessna 208 · Teslin Lake, CanadaNTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB LAX00LA301Accident · Minor injuriesLimited investigationFinal reportFollmer Q200 · Corona, CAThe failure and separation of one wooden propeller blade for undetermined reasons.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB DEN00LA152Accident · No injuriesLimited investigationFinal reportRosenbarger Lancair IV · Artesia, NMFailure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.NTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB ANC00LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent stall. A factor in the accident was the gusty winds.NTSB SEA00LA165Accident · Serious injuriesLimited investigationFinal reportLadd Nieuport 11 · White Pine, MTThe pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.NTSB NYC00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot's improper recovery from a bounced landing.NTSB NYC00LA227Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Columbus, OHThe pilot's failure to maintain airspeed, resulting from his improper go-around procedures following a rear engine failure. A factor was the pilot's improper fuel management, which resulted in the rear engine failure.NTSB LAX00LA298Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Grass Valley, CAThe pilot's failure to attain proper alignment with the runway during approach for landing. Contributing factors were the pilot's inadequate and improper preflight planning and in-flight decision.NTSB LAX00FA300Accident · 1 fatalField investigationFinal reportBeech K35 · Newberry Spring, CAThe crankshaft's fatigue failure at the site of an electrical arc mark stress riser, during cruise flight. Contributing factors were the pilot's inadequate preflight inspection, improper decision, and maintenance.NTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.NTSB FTW00LA232Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Helena, ARthe pilot's failure to maintain obstacle clearance. A contributing factor was the sun glare.NTSB FTW00LA231Accident · No injuriesLimited investigationFinal reportCessna T210L · Addison, TXthe electrical wire bundle fire during approach, which tripped the hydraulic motor circuit breaker resulting in collapse of the landing gear on landing.NTSB FTW00LA230Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Liberty Hill, TXthe pilot's inadvertent activation of the left rudder control, which resulted in a loss of control while in cruise flight.NTSB FTW00LA229Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Pettigrew, ARthe pilot's failure to maintain obstacle clearance during landing.NTSB DEN01LA026Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Longmont, COThe inadequate structural materials (American manufactured verses original Russian materials) used during a major repair.NTSB CHI00MA256Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Ironwood, MIthe pilot's improper in-flight decision, the pilot's continued flight into known adverse weather, the pilot's failure to turn on the continuous ignition in turbulence, and the pilot's failure to follow the procedures for an airstart. Factors included the…NTSB CHI00LA257Accident · 1 fatalLimited investigationFinal reportAyres S2R-600 · Bad Axe, MIThe inadvertent stall/spin encountered by the pilot. A factor was the low altitude.NTSB SEA00LA161Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Thompson Lake, MTAn improper flare which lead to a hard landing and subsequent main gear collapse as a result of the overload.NTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…NTSB NYC00LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Sloatsburg, NYThe pilot's failure to maintain aircraft control. A factor was the pilot's diverted attention.NTSB LAX00GA297Accident · 1 fatalFinal reportBell 412 · Cold Springs, NVfailure of the compressor turbine disc due to cyclic fatigue brought about by repeated operation near or above the engines' temperature/power limits by company personnel over an extended period of time. Factors in the accident were: 1) the high density…NTSB IAD00LA074Accident · Serious injuriesLimited investigationFinal reportUnknown Bensen Gyrocopter · Macedon, NYpilot's failure to maintain control of the gyrocopter. Factors in the accident were the pilot's lack of total flight experience and familiarity with the gyrocopter.NTSB DEN00LA151Accident · No injuriesLimited investigationFinal reportCessna 310D · Watkins, COThe pilot's failure to follow procedures and lower the landing gear prior to landing. Factors were diverted attention and aural perception.NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.NTSB NYC00LA230Accident · No injuriesLimited investigationFinal reportRedsell Windrose · Marion, OHThe pilot's failure to maintain control of the glider. Factors in this accident were the strong crosswinds, and thermals, which existed during the flight.NTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.NTSB NYC00FA225Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Cherry Valley, NYThe pilot's improper decision to continue the flight into deteriorating weather, which resulted in his failure to maintain control of the airplane. Factors in the accident were the dark night, fog, low ceiling, and the pilot's inadequate preflight planning.NTSB MIA00WA236Accident · No injuriesForeign investigationBeech B200 · Spanish Cay, BahamasNTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX00LA294Accident · No injuriesLimited investigationFinal reportDickenson Avid Magnum · Ely, NVThe pilot's inadequate compensation for a gusting crosswind that resulted in a loss of directional control and subsequent collision with the ground.NTSB LAX00LA293Accident · 2 fatalLimited investigationFinal reportBarclay/Vincent Murphy SR 2500 · Bakersfield, CAAdjustment by other maintenance personnel of the idle speed stop screw. The idle speed stop screw was backed off from the throttle shaft arm, not allowing the butterfly valve to operate properly, which resulted in the butterfly valve remaining closed during a…NTSB IAD00LA073Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kidron, OHthe pilot's failure to maintain a proper glide path and proper visual lookout that resulted in collision with wires.NTSB FTW00IA228Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · San Angelo, TXthe improper installation of the right elevator trim control wheel by company mechanics, which resulted in an elevator trim malfunction.NTSB DEN00LA150Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Edwards, COLack of crew coordination when the ground crew failed to hold the balloon in position following landing as the pilot expected them to do. A factor was power lines.NTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB CHI00LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Coopersville, MIfuel starvation due to the blocked carburetor. Factors relating to the accident were the foreign object (tab), the improper maintenance performed on the carburetor, and the corn crop.NTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.