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 DEN06IA056Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Denver, COthe failure of the elevator down cable due to an improperly routed cable by unknown maintenance personnel. A contributing factor was the improper inspection of the elevator cable by the operator's maintenance personnel.NTSB CHI06CA106Accident · No injuriesData collectionFinal reportWaco EQC-6 · Battle Creek, MIThe maintenance facility failed to properly install and inspect the rudder cable system resulting in the reversed rudder condition which made directional control not possible during the aborted takeoff. A contributing factor was an inadequate preflight…NTSB ATL06LA061Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Folkston, GAThe total loss of engine power due to the failure of the compressor turbine blades due to high temperature exposure.NTSB DFW06LA094Accident · No injuriesLimited investigationFinal reportAviation Specialties Unlimited Challenger II · Coushatta, LAThe loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.NTSB DCA06FA033Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC10 · Memphis, TNThe rupture of a fatigue crack in the forward air seal tooth serration of the No. 3 engine low pressure turbine stage 1 disk that initiated due to an improper weld repair performed during original manufacture. The improper weld repair changed the material…NTSB LAX06CA167Accident · No injuriesData collectionFinal reportCessna 310N · Lincoln, CAThe collapse of the nose gear due to an out of tolerance nose gear over center adjustment.NTSB ANC06LA043Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Iliamna, AKThe pilot's delayed use of carburetor heat, which resulted in a loss of engine power during cruise, and an in-flight collision with snow-covered terrain. Factors associated with the accident were an unfavorable wind, and the pilot's inadvertent stall of the…NTSB NYC06CA087Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. A factor was the gusting winds.NTSB MIA06LA078Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Parrot · Palm City, FLThe failure of the pilot-in-command to abort the takeoff after recognizing the engine was not developing full power during the takeoff roll. A contributing factor in the accident was the bending of the throttle cables which prevented full movement of the…NTSB LAX06CA135Accident · Minor injuriesData collectionFinal reportCessna T210H · Wells, NVthe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain directional control.NTSB CHI06CA103Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Grayslake, ILThe pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.NTSB ATL06LA060Accident · Serious injuriesLimited investigationFinal reportJust Highlander · Walhalla, SCThe pilot and owner/builders failure to determine the reason for partial loss of engine power resulting in loss of engine power due to fuel system contamination on a subsequent flight.NTSB ATL06LA059Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Cullman, ALThe pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.NTSB LAX06LA134Accident · No injuriesLimited investigationFinal reportBell UH-1H · Yuba City, CAThe pilot's in-flight loss of control of the helicopter for undetermined reasons. A factor was the trees.NTSB DEN06LA055Accident · Serious injuriesLimited investigationFinal reportMcLaughlin Rans S-7 · Hudson, COthe pilot's failure to maintain control of the airplane during an attempted landing. Contributing factors include the pilot's improper in-flight planning and decision making, the pilot's lack of experience in tailwheel airplanes, the pilot's lack of a…NTSB ATL06LA058Accident · Serious injuriesLimited investigationFinal reportCessna 182T · Double Springs, ALThe pilot's failure to maintain airspeed resulting in a stall. A factor in the accident was the pilot's physical impairment due to dementia and his failure to report the medical condition to the aviation medical examiner..NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB MIA06LA077Accident · 2 fatalLimited investigationFinal reportMarvin T Eiland SparrowHawk · Ona, FLThe in-flight loss of control for undetermined reasons during a normal descent, resulting in an uncontrolled descent, and in-flight collision with terrain.NTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB DEN06CA054Accident · No injuriesData collectionFinal reportCessna 170B · Benton, KSthe pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…NTSB NYC06LA086Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Clay Township, PAA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB NYC06CA094Accident · No injuriesData collectionFinal reportCessna 150M · Hazleton, PAThe student pilot's improper recovery from a bounced landing, resulting in a hard landing.NTSB LAX06FA133Accident · 1 fatalField investigationFinal reportRockwell 112 TCA · La Canada, CAThe pilot's failure to maintain aircraft control and an adequate airspeed during climb to cruise that led to a stall/spin. Contributing to the accident were the clouds and the pilot's physiological state.NTSB LAX06CA140Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Victorville, CAan in-flight collision with a bird.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB ANC06LA041Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mammoth Lake, CAThe collapse of the right main landing gear during landing, which resulted in a loss of directional control and an on-ground encounter with a snowbank. A factor associated with the accident was other maintenance personnel's inadequate inspection of the…NTSB ANC06CA039Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Dixon, CAThe pilot's failure to attain altitude/clearance during takeoff/initial climb, which resulted in an in-flight collision with terrain. Factors associated with the accident were the pilot's inadequate evaluation of the weather, and unfavorable winds.NTSB MIA06WA076Accident · 4 fatalForeign investigationCessna R172K · Cambita Garabit, Dominican RepublicNTSB MIA06LA074Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLFailure of the nose landing gear upper drag brace assembly due to overload acting on an undetected forging defect formed during the initial forging of the brace. A contributing factor in this accident was the runway distance remaining sign.NTSB MIA06LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bunnell, FLThe failure of the pilot to perform a preflight inspection of the airplane resulting in departure with an inadequate oil supply, subsequent engine failure due to oil starvation, and damage to the airplane during a forced landing. Contributing to the accident…NTSB LAX06FA131Accident · 2 fatalField investigationFinal reportCessna 208B · Oak Glen, CAThe pilot's continued flight into instrument meteorological weather conditions and his subsequent failure to maintain an adequate airspeed while maneuvering, that led to a stall/spin.NTSB DFW06WA091Accident · 6 fatalForeign investigationCessna 206 · Medellin, ColombiaNTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB MIA06LA071Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Dorado, PRThe failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.NTSB LAX06WA132Accident · 1 fatalForeign investigationCessna A188B · Narrandera, AustraliaNTSB DFW06WA090Accident · 2 fatalForeign investigationCessna 150 · San Luis Potosi, MexicoNTSB ANC06LA035Accident · Minor injuriesLimited investigationFinal reportClaypool RV-6A · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in a hard landing, the collapse of the nose landing gear, and a nose over. A factor associated with the accident was the pilot's failure to perform a go-around.NTSB ANC06CA040Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the snow covered terrain.NTSB ANC06CA037Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Marana, AZThe pilot's inadequate evaluation of weather conditions and loss of directional control, which resulted in the airplane exiting the runway during the takeoff roll, and striking a sign. A factor associated with the accident was a dust devil.NTSB MIA06CA072Accident · No injuriesData collectionFinal reportPiper PA32-301 · Key West, FLThe failure of the pilot to maintain directional control during the landing roll with a crosswind, resulting in collapse of the nose landing gear.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB DFW06CA092Accident · No injuriesData collectionFinal reportWaterwings SeaRey · Vicksburg, MSThe pilot's inadvertent reduction of power resuting in a collision with water. Contributing factors were the low altiude selected and the pilot's inattention.NTSB CHI06LA101Accident · No injuriesLimited investigationFinal reportCessna 180G · Eveleth, MNThe pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane departing the left side of the runway. Contributing to the accident was the airport fence and the drainage ditch.NTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.NTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.NTSB MIA06CA102Accident · No injuriesData collectionFinal reportPiper 38-112 · Apopka, FLThe pilot's failure to maintain clearance from an object while taxiing which resulted in the airplane impacting the object and incurring damage.NTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.NTSB CHI06CA104Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Tower, MNThe unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.