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 MIA05WA025Accident · Minor injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB MIA05LA021Accident · 1 fatalLimited investigationFinal reportJ.D. Calhoun Vans Acft RV6A · Weirsdale, FLFailure of the nose landing gear for undetermined reasons, resulting in the airplane nosing over during the landing roll, and the pilot's decision to operate the airplane with known deficiencies in the nose landing gear. A factor contributing to the fatality…NTSB ATL05CA019Accident · Serious injuriesData collectionFinal reportCessna 172N · Columbia, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB MIA05FA020Accident · 1 fatalField investigationFinal reportRawdon Bros. T1 · Pembroke Pines, FLImproper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…NTSB LAX05LA025Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Sierra Vista, AZAn inconsistency between the engines' two N2 sensor signals caused the fuel control to enter a fixed mode, which limited the power available. Contributing to the accident was the lack of altitude and airspeed available to give the pilot time to select a…NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB DEN05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTthe loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB MIA05LA018Accident · No injuriesLimited investigationFinal reportCessna 340A-RAM VI · Pensacola, FLThe left landing gear collapsing due to the actuator separating for undetermined reasons.NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.NTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.NTSB DFW05WA013Accident · Serious injuriesForeign investigationBölkow BO-105-LS · Puerto Plata, Dominican RepublicNTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB CHI05CA027Accident · No injuriesData collectionFinal reportCessna T182T · Morris, ILThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control. Factors associated with the accident were the gusty crosswind condition and the runway sign which the airplane contacted.NTSB SEA05FA013Accident · 1 fatalField investigationFinal reportCessna 172P · Olympia, WAThe pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB LAX05LA021Accident · No injuriesLimited investigationFinal reportCessna 210A · North Las Vegas, NVloss of engine power for undetermined reasons.NTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB CHI05FA020Accident · 3 fatalField investigationFinal reportBeech A36 · Downing, MOThe pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.NTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.NTSB ATL05LA017Accident · Serious injuriesLimited investigationFinal reportDavid Nielson Ison Hi-Max 1700 · Hendersonville, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB ANC05CA012Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep crusted snow.NTSB ANC05CA011Accident · No injuriesData collectionFinal reportChampion 7FC · Talkeetna, AKThe instructor pilot's inadequate supervision of the student, which resulted in a loss of control during the landing roll, and subsequent nose over.NTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.NTSB MIA05WA026Accident · Minor injuriesForeign investigationCessna 337G · San Fernando, ArgentinaNTSB DEN05LA022Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pueblo, COThe pilot’s inadequate compensation for wind and his failure to maintain aircraft control which resulted in a gear collapse due to an on-ground collision with terrain. Contributing factors were the wind shear, gusty wind conditions, and rough terrain. This…NTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB ATL05CA016Accident · No injuriesData collectionFinal reportCessna 172 · Mobile, ALThe pilot's inadequate preflight planning and his inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent collision with the ground.NTSB ANC05CA013Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep wet snow.NTSB MIA05LA019Accident · No injuriesLimited investigationFinal reportScottish Bulldog 120/121 · Jacksonville, FLThe pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB NYC05LA013Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAThe flightcrew's misjudged clearance from a parked airport vehicle while taxiing. A factor was the vehicle operator's improper decision to park within a taxiway safety area.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB IAD05LA008Accident · 1 fatalLimited investigationFinal reportCessna 180 · Freedom, PAThe pilot's failure to maintain obstacle clearance during the takeoff resulting in an in-flight collision with trees.NTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.NTSB CHI05FA017Accident · 2 fatalField investigationFinal reportCessna 182J · Springfield, MOThe pilot's failure to maintain a proper altitude and his failure to maintain obstacle clearance while turning to reverse direction on final approach. A factor associated with the accident was the night lighting conditions which existed at the time of the…NTSB ATL05FA013Accident · 4 fatalField investigationFinal reportBeech BE-60 · Asheville, NCThe pilot's failure to follow emergency procedures and to maintain airspeed following a loss of engine power during takeoff, which resulted in an inadvertent stall/spin and subsequent uncontrolled impact with terrain. Contributing to the cause was inadequate…NTSB NYC05LA010Accident · Serious injuriesLimited investigationFinal reportFairchild 24R-40 · Custar, OHThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.NTSB NYC05LA009Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Dulles, VAThe pilot's improper in-flight decision to continue the instrument approach and landing, which resulted in a collision with a sign. A factor was the below instrument approach landing minimum weather conditions.NTSB MIA05LA015Accident · Serious injuriesLimited investigationFinal reportDavid Cadorette Fox Model II · Vero Beach, FLLoss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.NTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.NTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.NTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.NTSB CHI05LA018Accident · No injuriesLimited investigationFinal reportKramer Glasair III · Schaumburg, ILFuel starvation for undetermined reasons during initial climb after takeoff. Contributing factors were the fence and fence post impacted during the forced landing.NTSB CHI05FA016Accident · 2 fatalField investigationFinal reportCessna P210N · Wautoma, WIThe pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…NTSB ATL05LA012Accident · No injuriesLimited investigationFinal reportRogers Lancair IVP · Sylvester, GAThe loss of engine power for undetermined reasons.