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 CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.NTSB ATL04CA174Accident · No injuriesData collectionFinal reportGrumman American AA1C · Boone, NCThe pilot's selection of the wrong runway, and his misjudgment of the distance and speed during the approach to land, which resulted in the overrun of the runway surface and subsequent collision with trees. A factor was tailwind.NTSB ANC04LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cantwell, AKAn in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.NTSB ANC04FA102Accident · 2 fatalField investigationFinal reportPiper PA-12 · Koliganek, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall and an uncontrolled descent.NTSB SEA04LA179Accident · Minor injuriesLimited investigationFinal reportHardin Lancair 320 · Chewelah, WAFuel exhaustion as a result of a fuel leak from an undetermined location resulting in a loss of engine power during approach for landing and subsequent forced landing. Soft terrain was a factor.NTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB MIA04LA126Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Greenville, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.NTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.NTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW04CA233Accident · No injuriesData collectionFinal reportSenior Aero Sport D-260 · Mc Kinney, TXThe pilot's failure to obtain and maintain proper alignment with the runway centerline during the landing roll.NTSB DEN04LA133Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hayden, COthe pilot's failure to maintain aircraft control during landing. Contributing factors include the excessive crosswind component, and the gusty wind conditions.NTSB ANC04LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, and his failure to maintain directional control which resulted in a loss of control, an encounter with a ditch, and the airplane nosing over. A factor in the accident was a crosswind.NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…NTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA226Accident · 1 fatalLimited investigationFinal reportCassutt Iiim · Pearland, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin while turning from the base leg of the traffic pattern to final. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DEN04LA144Accident · No injuriesLimited investigationFinal reportAviat A-1 · Greeley, COthe pilot's improper in-flight decision to land on an unimproved surface and the pilot's failure to maintain aircraft control. Contributing to the accident was the soft landing surface.NTSB CHI04CA250Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Crivitz, WIThe proper touchdown point not attained by the pilot during landing. The road and tailwind were contributing factors.NTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.NTSB NYC04WA203Accident · 3 fatalForeign investigationPiper PA-31P-425 · Sevilla, SpainNTSB DCA04WA081Incident · No injuriesForeign investigationBoeing 737-300 · Glasgow, United KingdomNTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB ANC04LA100Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cordova, AKThe pilot's failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a runway marker sign. A factor contributing to the accident was sunglare in the pilot's eyes.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB LAX04LA308Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · San Rafael, CAA total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA225Accident · No injuriesLimited investigationFinal reportBoeing 727-2M7 · El Paso, TXThe first officer's failure to maintain aircraft control. Contributing factors were the captain's delayed remedial action and the crosswind.NTSB DCA04WA078Accident · Serious injuriesForeign investigationBoeing 747-400 · Hanamaki, JapanNTSB SEA04WA177Accident · 2 fatalForeign investigationCessna 421 · Station Townshi, AustraliaNTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…NTSB DCA04WA083Accident · No injuriesForeign investigationFairchild SA226-T · Sydney, AustraliaNTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB IAD04LA050Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135KL · Clyde, NYAn unexpected encounter with clear air turbulence.NTSB IAD04CA042Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Ocean City, NJThe pilot's deliberate delay of rotation during the takeoff roll, and his subsequent loss of directional control.NTSB FTW04WA230Accident · 3 fatalForeign investigationPiper PA-30 · Aldama, MexicoNTSB DEN04CA137Accident · No injuriesData collectionFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.NTSB DEN04CA132Accident · Serious injuriesData collectionFinal reportCameron Balloons A-210 · Albuquerque, NMthe passenger losing her balance during the landing. Contributing to the accident was the increased wind velocity.NTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.NTSB NYC04WA208Accident · 1 fatalForeign investigationCessna 337C · Bresso, ItalyNTSB NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.NTSB NYC04CA199Accident · No injuriesData collectionFinal reportRobinson R44 · Wildwood, NJThe pilot's inadequate visual lookout while conducting a nighttime landing to a dolly, which resulted in a stuck skid, and subsequent hard landing. A factor was the nighttime conditions.NTSB NYC04CA198Accident · No injuriesData collectionFinal reportPettigrew, Richard RV-6A · Williamstown, NJThe pilot's improper flare, which resulted in a hard landing.NTSB LAX04LA305Accident · Serious injuriesLimited investigationFinal reportGibbs Kitfox IV · Payson, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent collision with terrain. Contributing factors to the accident were the turbulence and the gusting wind conditions.NTSB LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.