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 NYC06LA165Accident · 1 fatalLimited investigationFinal reportNorth American Navion · Sturgis, KYA total loss of engine power due to a leaking fuel pump gasket.NTSB NYC06CA168Accident · No injuriesData collectionFinal reportLiberty Aerospace XL2 · Mansfield, MAThe pilot's improper recovery from a bounced landing.NTSB DFW06FA173Accident · 1 fatalField investigationFinal reportCessna 180K · Owasso, OKThe pilot's selection of unsuitable terrain, a residential street, for both takeoff and landing, which resulted in a collision with a static wire and terrain during takeoff-initial climb.NTSB ATL06CA100Accident · Serious injuriesData collectionFinal reportNickel Acro II · Hertford, NCThe certified flight instructor and commercial pilot receiving instruction failure to maintain a visual look out, resulting in a wire strike on final approach, and collapse of the main landing gear on touchdown.NTSB ANC06LA087Accident · Minor injuriesLimited investigationFinal reportKennedy Chinook Plus 2 · Willow, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff/initial climb, which resulted in an uncontrolled descent and collision with trees. A factor associated with the accident was an inadvertent stall.NTSB ANC06CA083Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in the left wing striking the ground and a runway edge light. Factors contributing to the accident were the pilot's inadvertent application of the…NTSB SEA06LA134Accident · 3 fatalLimited investigationFinal reportTaylor Royal T · Davenport, WAThe pilot's failure to maintain aircraft control while maneuvering, resulting in a collision with terrain.NTSB NYC06LA167Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Toms River, NJCarburetor icing, and the pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent force landing. A factor in the accident was carburetor icing conditions.NTSB LAX06FA222Accident · 2 fatalField investigationFinal reportRaytheon A36 · Somis, CAa ground collision during an emergency landing for undetermined reasons.NTSB DFW08WA205Accident · 5 fatalForeign investigationCessna T210N · Poptun, GuatemalaNTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.NTSB CHI06LA175Accident · 1 fatalLimited investigationFinal reportCessna A185E · Clear Lake, MNThe pilot's misjudged flare that resulted in a hard landing and subsequent nose over. A factor to the accident was the grass runway that the forward landing gear dug into during the hard landing, resulting in the amphibian airplane nosing over.NTSB ATL06LA099Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Ringgold, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation resulting in a forced landing, and collision with trees and the ground.NTSB ANC06LA084Accident · No injuriesLimited investigationFinal reportBeech P35 · Gustavus, AKThe fracture of an engine connecting rod during cruise flight, which resulted in a forced landing on a beach, a collapsed nose landing gear, and substantial damage to the fuselage.NTSB ANC06CA082Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · St. Augustine, FLThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a nose over when the airplane departed the runway.NTSB WAS06WA011Accident · 3 fatalForeign investigationCessna 208B · Vilanculos, MozambiqueNTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.NTSB NYC06LA163Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Smyrna, DEThe pilot's misjudged fuel calculations, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the nighttime lighting conditions.NTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.NTSB CHI06GA174Accident · Minor injuriesFinal reportBell UH-1H · Chicago, ILThe in-flight separation of a tail rotor driveshaft hanger bearing due to inadequate maintenance performed by maintenance personnel. Contributing to the accident was the inability to maintain directional control due to the lack of tail rotor thrust.NTSB CHI06FA173Accident · 1 fatalField investigationFinal reportBell 206B · Walford, IAThe pilot's failure to maintain clearance from powerlines. The powerlines were a factor.NTSB ATL06CA098Accident · No injuriesData collectionFinal reportMooney M20M · Burnsville, NCThe pilot's failure to achieve the proper touch down point on landing resulting in a runway over run and collision with an embankment.NTSB ANC06WA142Accident · Minor injuriesForeign investigationBell 206B · Fontas, Alberta, CanadaNTSB NYC06WA166Accident · 1 fatalForeign investigationPiper PA-23-250 · Thirkleby, United KingdomNTSB LAX06CA224Accident · No injuriesData collectionFinal reportMooney M20M · Searchlight, NVthe pilot's encounter with rocks and debris on the runway during landing.NTSB LAX06CA221Accident · No injuriesData collectionFinal reportRobinson R-44 · Fresno, CAthe pilot's failure to maintain directional control following a loss of tail rotor effectiveness while in a downwind hover.NTSB DFW06LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Midland, TXThe partial loss of engine power as result of the maintenance personnel's failure to comply with a manufacture's Service Bulletin (SB). A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06IA171Incident · No injuriesIncident investigationFinal reportMooney M20J · Beaumont, TXThe improper installation of the propeller governor by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Orlando, FLThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a on-ground encounter with the runway, and subsequent nose over. A factor contributing to the accident was an inadvertent ground loop.NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.NTSB SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.NTSB LAX06LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chino Hills, CAA loss of aircraft control for undetermined reasons.NTSB LAX06CA219Accident · Minor injuriesData collectionFinal reportCessna 170B · Vacaville, CAthe pilot's failure to maintain directional control. A contributing factor was pilot fatigue.NTSB ANC06FA080Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's failure to maintain adequate airspeed while performing a low level pass, which resulted in an uncontrolled descent and collision with terrain. A factor contributing to the accident was an inadvertent stall.NTSB NYC06LA160Accident · 1 fatalLimited investigationFinal reportAerial Productions Intl. Acrojet Special · Ocean City, MDThe pilot's failure to maintain adequate airspeed which resulted in a stall mush and subsequent impact with trees. A factor in the accident was windshear, and the high weight of the airplane.NTSB LAX06CA218Accident · No injuriesData collectionFinal reportCessna T206H · Santa Maria, CAthe pilot's failure to maintain directional control during landing.NTSB LAX06CA217Accident · No injuriesData collectionFinal reportBeech 76 · El Cajon, CAthe failure of the "A" frame tube, which caused the left main landing gear to collapse.NTSB LAX06CA216Accident · Minor injuriesData collectionFinal reportEklund Thorp T-18 · San Andreas, CAthe pilot's misjudged airspeed and distance during the approach, and his failure to initiate a timely go-around, which resulted in a landing overrun.NTSB DFW06CA168Accident · No injuriesData collectionFinal reportCessna TU206G · Eldorado, TXThe pilot's failure to maintain airspeed during an emergency simulation resulting in a hard landing. A contributing factor was the flight instructor's delayed remedial action.NTSB DFW06CA167Accident · Minor injuriesData collectionFinal reportAgin Jeffrey T RV-4 · Arlington, TXThe pilot's improper recovery from a bounced landing.NTSB CHI06CA171Accident · Serious injuriesData collectionFinal reportCroke Zenith CH 701 · Brussels, WIThe pilot not maintaining clearance from the trees during final approach. The trees located along the final approach course were a factor in the accident.NTSB CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.NTSB NYC06FA156Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Philipsburg, PAThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.NTSB LAX06CA215Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Carlsbad, CAthe pilot's failure to maintain runway alignment during the aborted landing, which resulted in a collision with a tree.NTSB DFW06WA170Accident · 1 fatalForeign investigationCessna U206 · Chiguao, VenezuelaNTSB DFW06WA169Accident · No injuriesForeign investigationRaytheon Corporate Jets DH 125-3A · Barcelona, VenezuelaNTSB CHI06CA172Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minong, WIRestriction of the elevator control system due to the camera placed in the seat back pocket and the inadvertent stall/mush condition encountered during the go-around. The trees impacted after the stall were a contributing factor.NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…