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 MIA99IA249Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Nashville, TNA preexisting crack on the left main landing gear outer cylinder housing and the first officer's failure to maintain the proper rate of descent resulting in a hard landing on touchdown, and subsequent total failure and separation of the left main landing gear…NTSB LAX99TA299Accident · Minor injuriesFinal reportBell B212 · Bakersfield, CAThe failure of the pilot-in-command to maintain adequate visual surveillance to see and avoid power transmission wires known to be in the area.NTSB LAX99LA300Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-BETA · Piute, NVthe failure of the pilot to maintain rotor rpm while practicing autorotations, resulting in a hard landing and roll over.NTSB LAX99FA301Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Strathmore, CAThe failure of the pilot to maintain an adequate terrain and obstacle clearance altitude, which resulted in a collision with power transmission wires.NTSB FTW99LA267Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Van Horn, TXA restriction within the auxiliary fuel supply system and the rough terrain during the subsequent precautionary landing resulting on main gear collapse.NTSB FTW99LA254Accident · No injuriesLimited investigationFinal reportMooney M20D · Edna, TXFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB CHI99LA334Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nekoosa, WIthe pilot's inadequate compensation for wind gusts. Factors were the wind gusts and the two vehicles parked nearby.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB ATL99LA128Accident · No injuriesLimited investigationFinal reportCessna 182P · Collegedale, TNThe pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.NTSB ANC99LA137Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKA partial failure of the brake system. A factor associated with the accident was a leaking brake system.NTSB MIA99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Naples, FLThe pilot's failure to perform manual gear extension procedures with a suspected unsafe landing gear indication which resulted in a collapse of the main landing gear on landing rollout. A factor in the accident was the pilot's lack of total experience in kind…NTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.NTSB ANC99LA148Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Sleetmute, AKThe pilot's selection of an unsuitable landing area. A factor in this accident was the rough and uneven gravel bar.NTSB ANC99LA134Accident · No injuriesLimited investigationFinal reportCessna 180 · Dillingham, AKThe pilot's inadequate preflight planning. Factors associated with the accident were a short runway, and the pilot's failure to use available performance data.NTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW99LA248Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Ada, OKThe pilot's failure to maintain directional control of the airplane during the landing flare/touchdown. Factors were the pilot's excessive approach speed and the partial failure of the seat guides for the pilot's seat.NTSB FTW99LA247Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power resulting from a cylinder that failed for an undetermined reason.NTSB DEN99LA160Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Silverton, COThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI99LA352Accident · No injuriesLimited investigationFinal reportCessna 150M · Lebanon, MOA loss of engine power due to a fractured shaft supporting the number three cylinder rocker arm. A factor relating to this accident was the trees.NTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.NTSB CHI99LA319Accident · No injuriesLimited investigationFinal reportVan Grouw White Lightning · Greenfield, INimproper installation of the oil quick drain plug which resulted in oil exhaustion to the engine. A factor was the corn crop encountered during the forced landing.NTSB ATL99LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Buchanan, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice during glide and cruise, and rough and uneven terrain.NTSB ATL99LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, MSThe pilot's failure to switch the magneto switch to the both position before attempting a takeoff that resulted in the loss of engine power and resulted in the subsequent collision with trees.NTSB ANC99LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Nikolai, AKThe pilot's selection of an unsuitable takeoff and landing area. Factors associated with this accident were the unfavorable winds, and sunglare.NTSB ANC99LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe pilot's inadequate preflight planning. Factors associated with this accident were the pilot's failure to use the takeoff performance charts, the short runway and uphill takeoff, and a sudden windshift.NTSB NYC99FA220Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Westerly, RIThe pilot's loss of control of the airplane during a turn.NTSB LAX99LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, CAThe pilot's failure to maintain an adequate clearance from obstacles during taxi in a confined space.NTSB LAX99LA298Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Prescott, AZThe pilot's failure to maintain an adequate clearance from ground obstructions during an off-airport landing. The pilot's inability to locate suitable thermal activity to remain aloft is a factor in the accident.NTSB LAX99LA297Accident · No injuriesLimited investigationFinal reportCessna 205 · Gualala, CAThe pilot's failure to attain a proper touchdown point due to his misjudgment of the aircraft's speed, altitude, and distance to the runway. The pilot's failure to initiate a go-around is also causal.NTSB LAX99LA296Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Big Bear City, CAThe pilot's failure to follow the manufacturer's procedures to fully enrich the mixture, which induced an overly lean condition during full power application on the go-around and a resulting loss of power. The high density altitude weather condition was a…NTSB LAX99LA295Accident · No injuriesLimited investigationFinal reportCessna 150M · Menlo Park, CAThe fatigue failure of the left muffler rear wall, which resulted in hot exhaust gasses being ported onto, and shorting, the magneto p-lead wires. The failure of maintenance personnel to detect the impending failure of the muffler during the recent engine…NTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.NTSB DEN99LA174Accident · No injuriesLimited investigationFinal reportCessna P210N · Santa Fe, NMA non-mechanical total loss of engine power for reasons undetermined. Factors were maneuvering to avoid oncoming vehicles, and the rough and uneven terrain.NTSB ATL99LA124Accident · No injuriesLimited investigationFinal reportCessna 190 · Enterprise, ALThe fatigue failure of the main landing gear spring.NTSB ANC99LA150Accident · No injuriesLimited investigationFinal reportCessna 182 · Northway, AKThe improper maneuver to avoid obstructions by the pilot. Factors associated with this accident were the ruts in the approach end of the airstrip, and tall brush alongside the airstrip.NTSB ANC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKThe pilot's inadvertent stall. A factor was the intentional low altitude maneuvering by the pilot.NTSB SEA99LA156Accident · No injuriesLimited investigationFinal reportCessna 182M · Sandpoint, IDThe pilot's improper flare. Factors include a runway that sloped uphill, and the pilot's failure to familiarize himself with the destination airstrip prior to departure.NTSB SEA99LA154Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTThe pilot's failure to maintain directional control. A wet runway surface was a factor.NTSB SEA99LA153Accident · No injuriesLimited investigationFinal reportCessna 210B · Dixie, IDInadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.NTSB MIA99LA247Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLThe student pilots improper use of brakes on landing rollout resulting in a loss of directional control and subsequent collision with a ditch. Contributing to the accident was the certified flight instructors improper supervision of the student pilot.NTSB MIA99FA246Accident · No injuriesField investigationFinal reportDiamond Aircraft Industries DA20-A1 · Cedar Key, FLThe pilot's failure to follow the checklist (turn Fuel Valve-On, and activate electric fuel boost pump) and the pilot's decision to continue flight with a known unairworthy condition (illumination of low fuel pressure warning light on takeoff roll) with…NTSB CHI99LA320Accident · Serious injuriesLimited investigationFinal reportCessna 172D · South Wayne, WIthe pilot's improper selection of an emergency field and failure to maintain clearance from the trees. The cause of the loss of engine power was not determined.NTSB ANC99LA132Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Ninilchik, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with this accident was the sunglare.NTSB SEA99LA155Accident · No injuriesLimited investigationFinal reportSchwarzler Kolb Mark 3 · Independence, ORThe pilot's failure to maintain airspeed while on approach.NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB IAD99RA065Accident · 8 fatalForeign investigationCessna 404 · Linwood, United KingdomNTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.