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 MIA01WA035Accident · 2 fatalForeign investigationMooney M20M · Grunwald, AustriaNTSB LAX01WA051Accident · 2 fatalForeign investigationRobinson R-22B · Church Fenton, United KingdomNTSB LAX01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Paradise, CAFuel exhaustion during a descent due to an inadequate fuel supply. Contributing factors were the pilot's improper preflight planning, his misjudged altitude while performing the emergency landing, and his lack of certificate qualification and recent flight…NTSB CHI01FA044Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Milltown, WIThe flight instructor's inadequate supervision of the flight, the flightcrew not maintaining control of the airplane, and the flight instructor's delayed remedial action which resulted in the inadvertent spin. Factors to the accident were the inadvertent spin…NTSB ATL01LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNA loss of engine power during takeoff due to carburetor ice. A factor was unsuitable terrain.NTSB NYC01LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe overstress separation of the control yoke from the control column.NTSB SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.NTSB LAX01FA049Accident · 1 fatalField investigationFinal reportBeech BE-55-D55 · Clifton, AZthe pilot's improper in-flight decision to attempt a landing on an unlit runway at night, and his failure to maintain the proper glide path and clearance from obstacles while on final approach, which resulted in the collision with a utility pole. A…NTSB FTW01LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, TXthe loss of engine power during cruise flight due to the fatigue fracture of the compressor coupling adapter. A contributing factor was the high sea condition existing for the forced landing.NTSB NYC01LA049Accident · No injuriesLimited investigationFinal reportCessna 182J · College Park, MDThe pilot's inadequate flare, which resulted in a hard landing. A factor related to the accident was the downdraft wind conditions.NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB MIA01LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's failure to maintain a visual look out while transitioning from the active runway to a taxiway resulting in an on-ground collision with a taxiway sign.NTSB LAX01LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Marana, AZThe student pilot's improper flare and improper recovery from a bounced landing. A factor in the accident was the morning sun, which momentarily restricted the pilot's vision.NTSB LAX01LA047Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Kaunakakai, HIThe pilot's improper assessment of in-flight weather conditions, his inadequate compensation for winds, and his failure to maintain sufficient altitude and clearance on the lee side of mountainous terrain.NTSB DEN01LA025Accident · No injuriesLimited investigationFinal reportCessna 320C · Englewood, COthe failure of the nose landing gear to fully extend due to a bent extension rod.NTSB DEN01FA018Accident · 2 fatalField investigationFinal reportCessna 182P · Taos, NMthe pilot's failure to maintain terrain clearance while maneuvering in a narrow canyon. Contributing factors were the down slope winds in excess of 50 knots and the pilot's improper decision to enter the canyon given the wind conditions.NTSB ATL01LA018Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper flare during landing that resulted in a hard landing and the subsequent overload failure of the nose gear assembly.NTSB LAX01LA046Accident · No injuriesLimited investigationFinal reportCessna 305A · Mokuleia, HIThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control and subsequent ground loop.NTSB IAD01IA017Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Dulles, VAthe operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.NTSB DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB ATL01LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Florence, SCLoss of engine power due to carburetor icing, which resulted in a emergency landing into rough uneven terrain.NTSB NYC01LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Lebanon, OHThe flight instructor's failure to maintain aircraft control during an aborted takeoff. A factor in the accident was a partial loss of engine power.NTSB NYC01LA044Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Zanesville, OHThe pilot's failure to follow the restart procedures published in the approved flight manual(AFM). Factors were his failure to follow the fuel management procedures published in the AFM, which resulted in fuel starvation.NTSB FTW01WA030Accident · No injuriesForeign investigationFairchild SA227-AC · Trujillo, PeruNTSB FTW01LA029Accident · 2 fatalLimited investigationFinal reportLandes/Karich/Schmidt Christen Eagle II · Tyler, TXthe pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain terrain clearance.NTSB DCA01WA007Incident · No injuriesForeign investigationNairobi, KenyaNTSB ANC01LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot's selection of an unsuitable landing/taxi area. A factor associated with the accident was weak ice.NTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB FTW01LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Gainesville, TXthe loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…NTSB CHI01FA043Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Danville, ILThe pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…NTSB ATL01LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Merritt Island, FLMaintenance personnel failure to properly install engine cowling fasteners, which allowed the engine cowling to separate in flight.NTSB ATL01LA011Accident · No injuriesLimited investigationFinal reportMooney M20E · Fort Myers, FLFuel system contamination that resulted in fuel starvation.NTSB NYC01FA040Accident · 3 fatalField investigationFinal reportMooney M20K · Rixford, PAThe pilot's loss of control of the airplane while maneuvering. Factors included low ceilings and the pilot's lack of instrument flight experience.NTSB IAD01LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Boston, MAThe airplane's inadvertent encounter with severe turbulence.NTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.NTSB CHI01LA042Accident · No injuriesLimited investigationFinal reportAerostar PA-60-601P · Preston, MNaltitude/clearance from the trees not being obtained/maintained by the pilot. Factors to the accident were the trees and the contamination of the pitot/static system.NTSB NYC01LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Fremont, OHThe pilot's failure to obtain a proper touchdown point while landing. Factors were the pilot's improper weather evaluation, rain, a low ceiling, and a tailwind.NTSB IAD01IA019Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Newark, NJa short in the left inboard elevator parallel engage solenoid valve for undetermined reasons.NTSB FTW01LA027Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Antlers, OKthe loss of engine power resulting from carburetor icing conditions.NTSB MIA01WA033Accident · Serious injuriesForeign investigationCessna 172P · Port Au Prince, HaitiNTSB IAD01LA016Accident · Serious injuriesLimited investigationFinal reportBellanca BL-17-30A · Union, CTpilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB IAD01FA015Accident · No injuriesField investigationFinal reportBeech F90 · Lynchburg, VAImproper rigging of both propeller assemblies by maintenance personnel, which resulted in the inadvertent feathering of both propellers after takeoff. Factors included a lack of rigging experience in airplane make and model by maintenance personnel, unclear…NTSB FTW01WA031Accident · Serious injuriesForeign investigationCessna T210N · Chihuahua, MexicoNTSB CHI01LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Jefferson City, MOthe student pilots failure to maintain directional control. Factors were the service road and the nose gear collapse.NTSB SEA01LA024Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Lake Kachess, WAThe pilot's failure to comply with the flight manual regarding the use of an induction system deflector kit (snow baffles) while operating in snow, and the ingestion of foreign material/snow that resulted in an engine flameout while hovering. A snow baffle…NTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…NTSB ATL01LA013Accident · No injuriesLimited investigationFinal reportBeech BE-23-A24R · Jackson, MSDeer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.NTSB MIA01WA042Accident · No injuriesForeign investigationCessna 310L · Pitts Town, BahamasNTSB FTW01FA023Accident · 1 fatalField investigationFinal reportHall Glasair III · Gilmer, TXthe pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain aircraft control. A contributing factor was the pilot's lack of aerobatic experience.NTSB DEN01LA017Accident · 1 fatalLimited investigationFinal report2000 McCoy Genesis · Fort Collins, COFailure of an airframe stringer due to improper construction by the builder/pilot which rendered the aircraft uncontrollable. A factor was failure by the builder pilot to follow procedures and secure the engine prior to deploying the aircraft recovery…