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 CHI07LA168Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Lakewood, WIThe amphibian nose wheel strut assembly separated due to an overload fracture as a result of the manufacturer's inadequate design.NTSB ATL07CA090Accident · Minor injuriesData collectionFinal reportRosenbaum Super Petrel · Palm Harbor, FLThe pilot's failure to maintain directional control of the airplane during approach to land on a lake resulting in an inflight collision with water. A factor was the pilot's lack of qualification and total experience in the accident airplane make and model.NTSB ANC07LA048Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Tuluksak, AKThe loss of engine power during cruise due to the pilot's failure to refuel the airplane prior to fuel exhaustion. Factors contributing to the accident were the delayed extension of the gear, and the gear being unlocked at touchdown.NTSB SEA07LA156Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Ludlow, CAThe loss of engine power from both engines due to fuel starvation resulting from the pilot's improper fuel tank selector position. Contributing factors were the pilot's inadequate preflight inspection and the lack of suitable terrain for the forced landing.NTSB SEA07LA155Accident · No injuriesLimited investigationFinal reportQuad City Ultralight Challenger II · Lodi, CAThe improper assembly of the rony bracket which attached the right wing forward lift strut to the fuselage, the subsequent failure of that bracket, and separation of the right wing from the aircraft.NTSB SEA07LA154Accident · No injuriesLimited investigationFinal reportBell UH-1B · Biggs, CALoss of control during hover for undetermined reasons.NTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.NTSB DFW07CA140Accident · No injuriesData collectionFinal reportCessna 172G · Katy, TXThe student pilot's improper flare and his failure to recover from a bounced landing.NTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.NTSB NYC07LA136Accident · No injuriesLimited investigationFinal reportBeech K35 · Cross Junction, VAThe loss of engine power for undetermined reasons.NTSB NYC07CA132Accident · No injuriesData collectionFinal reportRobinson R-22B · Plant City, FLThe student pilot's failure to maintain directional control. Factors in the accident were variable wind conditions, and soft/uneven terrain.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB ATL07LA088Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Taylorsville, KYThe pilot's improper prefight inspection of the helicopter.NTSB ANC07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Koyukuk, AKThe pilot's inadequate compensation for a gusting tailwind during the landing roll, which resulted in a loss of control and a nose over. Factors contributing to the accident were the tailwind and wind gust.NTSB ANC07FA047Accident · No injuriesField investigationFinal reportPiper PA-32-300 · Kake, AKA fractured exhaust manifold, which resulted in an in-flight fire, and the inadequate inspection of the airplane by the operator's maintenance personnel.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB SEA07LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Redlands, CAThe restriction of the carburetor float as a result of a misadjusted retractor clip. A contributing factor was the fire.NTSB SEA07LA166Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe failure of the left main landing gear due to fatigue.NTSB SEA07LA152Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Santa Barbara, CAThe erroneous gross weight calculation and improper trim setting by the captain, which resulted in the airplane's failure to rotate at Vr as expected and the captain's decision to perform to a high speed aborted takeoff.NTSB SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB SEA07CA151Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Novato, CAThe instructor's failure to maintain directional control during landing. A contributing factor was the wind gusts.NTSB NYC07CA135Accident · No injuriesData collectionFinal reportCessna C-170A · Trenton, GAThe pilot's failure to maintain directional control during the landing roll which resulted in an impact with trees. Factors in the accident were the uneven narrow runway, and a wind gust.NTSB MIA07LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lantana, FLSeparation of a landing gear hydraulic line at the fitting for undetermined reasons.NTSB MIA07CA106Accident · Minor injuriesData collectionFinal reportCessna 150L · Greensboro, GAThe pilot's failure to retract the wing flaps during a go-around, which resulted in a stall, and uncontrolled descent, and an impact with terrain.NTSB DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to landing.NTSB NYC07LA138Accident · No injuriesLimited investigationFinal reportPiper PA38 · Jacksonville, FLThe pilot's failure to perform adequate pre-flight fuel consumption calculations, which resulted in a loss of power due to fuel starvation.NTSB MIA07CA108Accident · Minor injuriesData collectionFinal reportJames L. Stringfellow Glastar · Williston, FLThe pilot's misjudgment of distance/altitude and his improper touchdown point which resulted in an undershoot, nose over and damage to the airplane.NTSB DFW07CA131Accident · No injuriesData collectionFinal reportGrumman G-164A · Okarche, OKThe pilot's failure to maintain clearance from an unmarked light fixture.NTSB DEN07CA099Accident · No injuriesData collectionFinal reportAeronca 7AC · Erie, COThe student pilot's failure to maintain direction control during the landing roll.NTSB ANC07LA046Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Clear, AKThe dual student's misjudged distance/altitude during the final approach to land, and the flight instructor's inadequate supervision of the student, which resulted in an undershoot, and substantial damage.NTSB SEA07CA169Accident · No injuriesData collectionFinal reportBoeing Stearman A75N1 · Coeur d'Alene, IDThe pilot's failure to maintain directional control during landing. The crosswind condition was a contributing factor.NTSB NYC07LA134Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Gallatin, TNThe pilot’s mismanagement of fuel which led to fuel starvation and loss of engine power. Contributing to the accident was the pilot’s failure to utilize the proper engine restart procedures, and the hard landing.NTSB CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB SEA07FA148Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Quilcene, WAThe pilot's continued flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. Factors contributing to the accident included the low clouds which obscured the rising, mountainous terrain.NTSB NYC07CA133Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lumberton, NJThe flight instructor's improper decision to simulate an engine failure in the traffic pattern by cutting off fuel to the engine, and his subsequent failure to maintain directional control during an aborted landing.NTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB CHI07LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · New Smyrna Beac, FLThe propeller blade separation from the propeller hub due to a fatigue fracture of the hub while in cruise flight. A factor was the embankment.NTSB ANC07LA045Accident · No injuriesLimited investigationFinal reportCessna 177 · Centreville, ALThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and substantial damage during a forced landing on a road.NTSB SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…NTSB DFW07LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Oak Grove, LAA complete loss of power due to failure of the impeller drive gear train and displacement of the blower spring drive mechanism, which resulted in seizure of the propeller shaft/crankshaft. Also causal was the failure of the phenolic separator bracket of the…NTSB DFW07CA129Accident · No injuriesData collectionFinal reportGrumman G-164A · Sayre, OKThe partial loss of engine power on takeoff-initial climb for an undetermined reason. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB SEA07CA146Accident · No injuriesData collectionFinal reportCessna T210N · Bakersfield, CAThe pilot's improper flare, which resulted in a loss of directional control. Factors included the crosswind and gusty wind condition.NTSB MIA07WA105Accident · 2 fatalForeign investigationBell 206L-3 · Simiti, Bolivar, ColombiaNTSB CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.NTSB CHI07CA163Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · Walnut Ridge, ARThe pilot's failure to maintain directional control of the airplane upon landing, which resulted in the airplane impacting a rice levee. The rice levee and the tailwind condition were contributing factors to the accident.NTSB CHI07CA161Accident · No injuriesData collectionFinal reportWeatherly 201C · Mc Clusky, NDThe pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…NTSB ATL07GA087Accident · Serious injuriesFinal reportBell 206B · Cedartown, GAThe pilot's failure to maintain control of the helicopter while maneuvering. Contributing to the accident were strong gusty winds.NTSB SEA07CA150Accident · No injuriesData collectionFinal reportCessna 182P · Aurora, ORThe pilot's misjudged flare during landing, and his improper recovery from a bounced landing, resulting in collision with the runway.NTSB SEA07CA144Accident · No injuriesData collectionFinal reportBillings/Humbyrd Thorpe T-18 · Corona, CAA loss of engine power during the initial climb due to a fuel system malfunction. The pilot's incorrect maintenance modification to the fuel system and continued operation with known deficiencies were factors.NTSB NYC07FA130Accident · 1 fatalField investigationFinal reportMooney M20J · Canton, MAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.