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 SEA06CA080Accident · No injuriesData collectionFinal reportPitrolo GL-25 · Worden, MTThe loss of engine power due to failure of both electronic ignition systems. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA06CA096Accident · Minor injuriesData collectionFinal reportEurocopter Deutschland EC135T2 · Bonifay, FLThe pilot's failure to maintain main rotor rpm and proper descent rate resulting in a hard landing. A related factor in this accident was inadvertent encounter with clouds.NTSB CHI06FA117Accident · 5 fatalField investigationFinal reportCessna U206G · Bloomington, INThe pilot's continued descent below decision height and not maintaining adequate altitude/clearance from the trees while on approach. Factors were the the night lighting conditions, and the mist.NTSB CHI06CA118Accident · No injuriesData collectionFinal reportCessna T210L · Henryville, INThe pilot selected an empty fuel tank during the approach which resulted in fuel starvation and subsequent loss of engine power. A factor associated with the accident were the trees that the airplane contacted during the forced landing.NTSB ANC06TA047Accident · No injuriesFinal reportAmerican Eurocopter AS350 B3 · Nikiski, AKThe pilot's failure to maintain adequate altitude/clearance from terrain during an aborted takeoff in whiteout conditions, which resulted in an in-flight collision with terrain. A factor associated with the accident was whiteout conditions.NTSB NYC06FA100Accident · 2 fatalField investigationFinal reportBell 47G-3B-1 · East Hanover Tw, PAThe pilot's improper decision to hover out-of-ground-effect in a tailwind, and his failure to maintain aircraft control. A factor in the accident was the tailwind.NTSB LAX06CA143Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAthe failure of the student and certified flight instructor to maintain directional control and obtain/maintain an adequate airspeed during the attempted go-around. The flight instructor's inadequate supervision of the flight was also causal.NTSB DEN06LA067Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Arkansas City, KSthe pilot's failure to maintain clearance from the guide wire resulting in the airplane striking the wire and subsequently impacting the terrain.NTSB SEA06CA087Accident · No injuriesData collectionFinal reportCessna 310R · Billings, MTCollapse of the right main landing gear during the landing roll for an undetermined reason.NTSB SEA06CA083Accident · No injuriesData collectionFinal reportCubCrafters CC-18-180 · Logan, UTThe pilot receiving instruction failed to maintain airplane directional control during the landing roll, and the flight instructor's inadequate supervision. An inadvertent ground loop was a factor.NTSB MIA06CA095Accident · Minor injuriesData collectionFinal reportMarland E Davis RV-6A · Live Oak, FLFailure of the pilot to maintain directional control of the airplane during landing resulting in a nose over.NTSB DFW06LA093Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Houston, TXThe failure by maintenance personnel to secure the tail rotor driveshaft cowling after performing maintenance which resulted in a loss of tail rotor control. A contributing factor was the pilot's improper preflight inspection of the tail rotor driveshaft area.NTSB DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.NTSB DCA06WA035Accident · Serious injuriesForeign investigationBoeing 777 · Shanghai, ChinaNTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…NTSB CHI06CA120Accident · No injuriesData collectionFinal reportCessna 172E · Wadena, MNThe pilot's inadequate compensation for the wind conditions during the landing. Factors were the crosswinds, the gusts, and the ditch.NTSB SEA06CA078Accident · No injuriesData collectionFinal reportCessna 170B · Shelton, WAThe main landing gear wheel failure during the takeoff ground roll. A related factor was directional control of the aircraft was not possible after the wheel failure.NTSB MIA06TA093Accident · Minor injuriesFinal reportPiper PA-31-310 · St. ThomasThe loss of engine power in both engines for an unknown reason.NTSB DFW06LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Denton, TXThe flight instructor's failure to maintain rotor RPM, resulting in a hard landing.NTSB CHI06CA132Accident · No injuriesData collectionFinal reportCessna 177B · Cleveland, OHThe pilot's misjudged flare which resulted in a bounced landing, and his inadequate recovery from the bounced landing that led to a hard landing.NTSB ATL06WA067Accident · 2 fatalForeign investigationCessna 172M · Toledo, SpainNTSB SEA06LA077Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Clark Fork, IDThe pilot's failure to maintain aircraft control during a go-around. A quartering tailwind was a factor.NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.NTSB ANC06CA046Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain directional control of the airplane during takeoff initial climb, which resulted in an in-flight collision with trees.NTSB SEA06WA079Accident · No injuriesForeign investigationLake LA-4-200 · Lady Smith, CanadaNTSB NYC06LA097Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Avondale, PASeparation of the propeller blade due to fatigue.NTSB MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB MIA06FA090Accident · 3 fatalField investigationFinal reportBeech B-60 · Gainesville, FLThe loss of control for an undetermined reason.NTSB DFW06CA105Accident · No injuriesData collectionFinal reportParks RV-7 · Fort Worth, TXThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the prevailing crosswind.NTSB CHI06CA116Accident · No injuriesData collectionFinal reportPalulis John Exec 162F · Kalkaska, MIThe compensation for wind conditions not performed by the pilot during hover. An additional cause was the tailwind.NTSB ATL06CA068Accident · No injuriesData collectionFinal reportCessna 172S · Gainsville, GAThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA065Accident · No injuriesData collectionFinal reportCessna 172 M · Griffin, GAThe pilot's failure to achieve the proper touchdown point, which resulted in an overrun of the runway, collision with an embankment, and subsequent nose over.NTSB SEA06LA074Accident · No injuriesLimited investigationFinal reportCentral Copters Lancair IV-P · Belgrade, MTThe total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…NTSB NYC06LA099Accident · Serious injuriesLimited investigationFinal reportBombardier CL600-2B19 · Front Royal, VAAn inadvertent encounter with clear air turbulence.NTSB NYC06CA098Accident · No injuriesData collectionFinal reportCessna 310Q · Finleyville, PAThe pilot's misjudged distance/speed during final approach, which resulted in an undershoot and hard landing.NTSB NYC06CA096Accident · No injuriesData collectionFinal reportAeronca 7AC · Haverhill, NHThe flight instructor's inadequate preflight planning, which resulted in a forced landing and subsequent impact with a sign.NTSB DFW06LA103Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Meridian, MSThe pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.NTSB DEN06CA064Accident · No injuriesData collectionFinal reportRobinson R-22 · Santa Fe, NMthe pilot's improper preflight planning and his failure to maintain control of the helicopter during takeoff. Factors contributing to the accident were the helicopter exceeding its maximum gross weight for takeoff and the high density altitude.NTSB ANC06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Birchwood, AKThe flight instructor's delayed remedial action during the landing roll, which resulted in the loss of directional control by the student, a ground-loop, and collapse of the main landing gear. A factor associated with the accident was the student's failure to…NTSB SEA06LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include gusty crosswinds.NTSB MIA06WA094Incident · No injuriesForeign investigationCessna 208B · El Alto, BoliviaNTSB MIA06FA092Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Dunnellon, FLThe loss of engine power as a result of fuel starvation due to a contaminated carburetor fuel inlet screen.NTSB DFW06LA104Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Lubbock, TXAn in-flight electrical fire for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA063Accident · No injuriesLimited investigationFinal reportRumble/Williams/Boomhower Starduster II · Junction City, KSVapor lock which resulted in total engine failure and the pilot's abrupt brake application on touchdown. Factors contributing to the accident were the improper design of the fuel system resulting in the misrouting of the fuel lines close to the exhaust pipes,…NTSB CHI06LA112Accident · No injuriesLimited investigationFinal reportDassault Falcon 2000 · Stilesville, INThe separation of the left engine cowling during cruise flight for undetermined reasons.NTSB SEA06LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bullfrog Basin, UTA high airspeed at touchdown resulting in a high ground speed during the landing roll. Downhill sloping runway, a tailwind, the pilot's delayed remedial action and rough terrain off the end of the runway were factors.NTSB MIA06LA089Accident · No injuriesLimited investigationFinal reportBeech C24R · Panama City, FLA flat tire which occurred for undetermined reasons that resulted an inadvertent loss of control during the landing roll.NTSB DFW06FA102Accident · 2 fatalField investigationFinal reportRobinson R44 II · Fredericksburg, TXThe pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.NTSB DEN06LA062Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hope, NMA loss of engine power due to failed bearings in the turbocharger and the subsequent oil seal failure leading to oil exhaustion. Factors contributing to the accident were the fractured oil seal and the road sign.