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 ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.NTSB ATL04LA148Accident · No injuriesLimited investigationFinal reportCessna 401B · Naples, FLThe fracture of the right landing gear down lock stud which resulted in the right main landing gear collapse during landing roll.NTSB ATL04CA154Accident · No injuriesData collectionFinal reportGlassic Composites SQ-2000 XL · Dayton, TNThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop and the subsequent collapse of the landing gear.NTSB ATL04CA151Accident · No injuriesData collectionFinal reportCessna 182A · Walterboro, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL04CA149Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Tallassee, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. A factor was pilot fatigue and the unauthorized use of the airplane .NTSB SEA04LA130Accident · No injuriesLimited investigationFinal reportPetsche Kitfox Kitfox 7 · Arlington, WAThe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control while landing. A factor contributing to the accident was a direct crosswind.NTSB SEA04FA127Accident · Serious injuriesField investigationFinal reportExtra Flugzeugrau EA 300/L · Boise, IDThe failure of the pilot to maintain clearance with terrain during descent while conducting an aerobatic maneuver. Low altitude flight was a factor.NTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.NTSB FTW04LA180Accident · No injuriesLimited investigationFinal reportCessna 150M · Sherrill, ARthe pilot's inadequate in-flight planning/decision which resulted in the loss of engine power due to fuel exhaustion.NTSB CHI04LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Mason City, IAThe proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA180Accident · No injuriesData collectionFinal reportTexas Helicopter M-74 · Clear Lake, MNThe pilot failed to maintain a proper glidepath to the landing zone. A factor was the truck pad.NTSB SEA04CA126Accident · Minor injuriesData collectionFinal reportAmmeter RV-6 · Cascade, IDThe pilot's improper flare and his failure to maintain directional control. Factors contributing to the accident are rough/uneven terrain.NTSB LAX04LA256Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350 B2 · Hilo, HIthe pilot's inadequate planning/decision by his VFR flight into IMC, and his failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. A low ceiling and fog were contributing factors.NTSB FTW04CA181Accident · No injuriesData collectionFinal reportCessna 180E · Weiner, ARThe pilot's poor preflight preparation/planning which resulted in the pilot landing at a wrong airport. A contributing factor was the lack of suitable terrain for the off airport landing.NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.NTSB CHI04LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Waubun, MNThe pilot's failure to get the proper rest prior to the night cross country flight and the pilot's failure to maintain altitude. Contributing factors to the accident were fatigue as a result of inadequate sleep, conditions conducive to fatigue, and night.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB ATL04CA145Accident · No injuriesData collectionFinal reportCessna 172 RG · Fernandina, FLThe pilot's failure to follow the checklist and lower the landing gear prior to landing.NTSB ANC04LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakutat, AKThe pilot's selection of an unsuitable landing area, which resulted in the collapse of the landing gear, and subsequent nose over during the landing roll. A factor associated with the accident was soft terrain.NTSB SEA04LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wendell, IDA cracked cylinder head which resulted in a loss of engine power while maneuvering. High vegetation was a factor.NTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.NTSB LAX04LA253Accident · 1 fatalLimited investigationFinal reportAnderson Harmon Rocket II · Seal Beach, CAthe in-flight separation of the elevator, which resulted in a loss of airplane control and an uncontrolled descent. The underlying cause and mechanism of the elevator separation could not be determined.NTSB LAX04CA255Accident · Minor injuriesData collectionFinal reportCessna 172N · Chemehuevi, CAthe pilot's improper recovery from a bounced landing, inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane.NTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.NTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…NTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.NTSB DCA04WA069Accident · No injuriesForeign investigationLockheed L-1011-385-3 · Amsterdam, NetherlandsNTSB CHI04WA171Accident · 1 fatalForeign investigationPiper PA-28-181 · Qaqortoq, GreenlandNTSB CHI04IA178Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIThe fatigue fracture of the left main landing gear during landing roll.NTSB SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.NTSB NYC04FA157Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Wilmot, NHThe pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.NTSB IAD04LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Paxton, MAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing. Factors included the pilot's use of a fuel gauge that was calibrated for a different model airplane, and a lack…NTSB FTW04LA175Accident · No injuriesLimited investigationFinal reportAeronca/Bubeck Bubeck-Aeronca · Burleson, TXThe pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the night visual conditions, and the lack of suitable terrain for landing.NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.NTSB DEN04CA099Accident · No injuriesData collectionFinal reportCessna 172N · Laramie, WYfuel exhaustion due to the pilot's improper inflight decision not to stop and refuel. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB CHI04CA179Accident · No injuriesData collectionFinal reportWaco YMF-FSC · Lansing, ILThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. The crosswind and the ditch were contributing factors.NTSB CHI04CA176Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake City, MIThe pilot's failure to maintain directional control during landing.NTSB CHI04CA174Accident · No injuriesData collectionFinal reportCessna 182N · Lancaster, WIThe pilot's inadequate compensation for the gusty winds and his improper flare. The wind gusts were a contributing factor.NTSB CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.NTSB ANC04LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Chugiak, AKThe pilot's excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.NTSB SEA04LA121Accident · No injuriesLimited investigationFinal reportExp Acft Assn Wi Chapter 60 Moni · Rochester, WAThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power during descent. Factors contributing to the accident included the pilot's lack of experience in the aircraft and the tree.NTSB SEA04CA123Accident · No injuriesData collectionFinal reportCessna T210M · Mallard Creek, IDImproper touchdown during landing. A factor contributing to the accident was soft ground conditions.NTSB NYC04LA165Accident · No injuriesLimited investigationFinal reportCessna 172C · Pottstown, PAThe pilot's inadequate flare, which resulted in a hard landing.NTSB NYC04LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brighton Beach, NYA partial loss of engine power during cruise flight for undetermined reasons.NTSB NYC04CA159Accident · No injuriesData collectionFinal reportLuscombe 8F · Andover, NJThe pilot's failure to maintain aircraft control during approach. A factor was windshear.NTSB IAD04LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Wellsboro, PAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.