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 SEA06CA192Accident · No injuriesData collectionFinal reportAmorde Glasair II-S RG · Rockford, IDThe pilot's failure to maintain aircraft control during landing. A contributing factor was gusty winds.NTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.NTSB CHI06CA266Accident · No injuriesData collectionFinal reportMD Helicopters 369FF · Port Clinton, OHThe pilot not maintaining clearance from the water during the survey flight. A factor was the low altitude the survey flight was flown at.NTSB ANC06FA131Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. A factor associated with the accident was a low cloud ceiling.NTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoNTSB DFW06CA215Accident · No injuriesData collectionFinal reportMaule MT-7 · Ponca, ARThe pilot's improper flare resulting in a hard landing.NTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.NTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…NTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.NTSB DEN06GA128Accident · 2 fatalFinal reportPiper PA-23-250 · Fort Meade, FLA loss of power in the right engine while manuevering for reasons undetermined, and failure to maintain aircraft control which resulted in an inadvertent stall. Contributing factors were the airspeed below Vmc, and an altitude too low to afford a safe…NTSB DCA06WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesNTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…NTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaNTSB ENG06WA036Incident · No injuriesForeign investigationCessna 560 · Calgary, CanadaNTSB DEN06CA127Accident · No injuriesData collectionFinal reportPiper PA-46T-350P · Colo. Springs, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall. Contributing factors in this accident were the jet blast encounter, and the pilot's failure to initiate a go-around when he felt an unsafe condition existed.NTSB CHI06WA271Accident · No injuriesForeign investigationPiper PA-46-350P · Suwalki, PolandNTSB CHI06CA265Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Dayton, OHThe pilot's inadvertent wheels up landing.NTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB LAX06TA291Accident · No injuriesFinal reportCessna U206G · Wasco, CAThe pilot's improper decision in leaving the engine running while he left the airplane unattended.NTSB LAX06LA292Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Minden, NVThe inadequate pre-takeoff checks by the flightcrew that failed to detect that the spoilers were deployed during the takeoff and initial climb. Also causal was the inadequate supervision of the flight by the flight instructor.NTSB DCA06WA069Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandNTSB SEA06CA182Accident · No injuriesData collectionFinal reportMaule M-4-180V · Lewistown, MTThe airplane inadvertently impacted a coyote hole during the landing roll on unsuitable terrain.NTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.NTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.NTSB ANC06CA132Accident · No injuriesData collectionFinal reportPiper PA-12 · Noatak, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control during the landing roll and a nose over. Factors associated with the accident were soft terrain and the pilot's failure to maintain directional control.NTSB NYC06LA220Accident · Serious injuriesLimited investigationFinal reportFlight Design Ctsw · Tunkhannock, PAThe pilot's improper recovery from a bounced landing.NTSB LAX06LA293Accident · 2 fatalLimited investigationFinal reportChampion 7EC · Clipper Mills, CAThe pilot failed to maintain clearance from mountainous terrain. A contributing factor was the pilot's impairment from ingestion of marijuana.NTSB LAX06LA290Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Van Nuys, CAInadequate maintenance adjustment and missing mixture spring, which resulted in a loss of engine power during approach.NTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaNTSB CHI06CA259Accident · No injuriesData collectionFinal reportLuscombe 8E · Dodgeville, WIThe pilot encountering unsuitable terrain during the precautionary landing. A factor was the ditch the pilot encountered.NTSB DEN06CA125Accident · Minor injuriesData collectionFinal reportThomas Velocity · Conway, SCthe loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.NTSB DEN06CA123Accident · Serious injuriesData collectionFinal reportParsons JN4-D Jenny Replica · Crossville, TNA loss of control in flight due to a disconnected rudder control cable. Contributing to the accident was the pilot's inability to control the roll.NTSB CHI06LA258Accident · 1 fatalLimited investigationFinal reportGarner Garner Falcon · Newton, IAAn inflight collision with terrain during an unknown phase of flight. A factor was the pilot's lack of experience.NTSB ANC06CA126Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's excessive braking during the landing roll, which resulted in a loss of control and a nose over.NTSB NYC06LA222Accident · No injuriesLimited investigationFinal reportAirbus Industrie A319-112 · New York, NYThe Airbus first officer's misjudged clearance from the EMB-170. Also causal was the ground controller's decision to issue a taxi clearance for the Airbus to pass behind the EMB-170. A factor to the accident was the light condition.NTSB LAX06FA289Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Santa Maria, CAThe non-instrument rated pilot's decision to continue flight into instrument meteorological conditions resulting in spatial disorientation and a loss of control.NTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoNTSB WAS06WA014Incident · No injuriesForeign investigationBoeing 727-277 · Lagos, NigeriaNTSB SEA06CA177Accident · No injuriesData collectionFinal reportCessna 182RG · Shelton, WAThe pilot's failure to extend the landing gear prior to a practice soft-field landing, and the certified flight instructor's failure to take remedial action. Factors include the pilot's failure to use a checklist.NTSB NYC06LA219Accident · Minor injuriesLimited investigationFinal reportBeech F33A · South Windsor, CTA loosening of the fuel injector lines from the fuel manifold valve, which resulted in a partial loss of engine power.NTSB DFW06LA209Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Krum, TXThe CFI's and ATP's inflight decision to land halfway down the runway and the ATP's delayed decision to abort the landing. A factor was the ATP's excessive airspeed on final.NTSB DFW06LA208Accident · No injuriesLimited investigationFinal reportMorton Mustang II · Conroe, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Newton, MSThe total loss of engine power due to fuel contamination. A factor was the pilot's inadequate preflight inspection.NTSB SEA06CA178Accident · Minor injuriesData collectionFinal reportCessna 150 · Laurel, MTThe pilot's excessive application of the brakes during an aborted takeoff, which resulted in a nose over.NTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.NTSB LAX06GA287Accident · 2 fatalFinal reportNorth American OV-10A · Porterville, CAthe pilot's failure to maintain adequate terrain clearance while maneuvering over rising terrain in a box canyon. Also causal was the pilot's failure to adhere to procedures/directives regarding minimum altitude requirements.