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 CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB MIA96FA033Accident · 1 fatalField investigationFinal reportCessna 150M · Burlington, NCthe pilot's engagement in a low altitude ostentatious display from which he stalled the airplane.NTSB FTW96LA068Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Collinsville, OKThe pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.NTSB FTW96LA059Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Gallup, NMthe high winds and the pilot's failure to maintain aircraft control.NTSB FTW96FA058Accident · 3 fatalField investigationFinal reportCessna 172P · Hallett, OKThe flight instructor's intentional low altitude flight maneuver. Factors were the static wire and the bright night condition.NTSB CHI96LA046Accident · No injuriesLimited investigationFinal reportRobert Eckley Rotorway · Salina, KSthe pilot's improper maintenance of the helicopter. Factors in the accident were the pilot's lack of proper certification for the operation of the helicopter and his lack of recent experience in type of aircraft.NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB LAX96LA060Accident · Serious injuriesLimited investigationFinal reportLaister LP-15 · Adelanto, CAthe pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB CHI96LA044Accident · Minor injuriesLimited investigationFinal reportHerring Sport FAN · Newton, KSa loss of engine power for undetermined reasons. A factor related to the accident was the presence of traffic requiring the pilot to perform an evasive maneuver.NTSB BFO96LA030Accident · No injuriesLimited investigationFinal reportCessna 172K · Lovingston, VAthe pilot's improper planning/decision during the approach/landing phase of flight. Related factors were: the pilot's selection of the wrong runway, and the gusty tailwind conditions.NTSB ATL96LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, SCAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.NTSB ATL96LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alexander City, ALThe leaking fuel injector, which created a rich mixture, and caused the aircraft engine to lose power.NTSB MIA96LA032Accident · No injuriesLimited investigationFinal reportKoutz Q-200 · Valdosta, GAThe pilot's failure to maintain directional control. The crosswind was a factor.NTSB LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB FTW96LA057Accident · Serious injuriesLimited investigationFinal reportBeech D18S · Loveland, COThe second pilot's failure to compensate for wind conditions and his improper recovery from a bounced landing, and the pilot-in-command's inadequate supervision of the flight. Factors were the second pilot's lack of landing experience in the airplane…NTSB BFO96FA027Accident · 2 fatalField investigationFinal reportGraichen Christen Eagle II · Malinta, OHfailure of the pilot to maintain proper altitude, while performing aerobatic maneuvers.NTSB SEA96WA033Accident · 5 fatalForeign investigationRockwell AC-700 · Castlegar, CanadaNTSB SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB LAX96LA066Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Chino, CAthe pilot's failure to see and avoid light poles. A poorly planned approach was a factor.NTSB LAX96LA059Accident · No injuriesLimited investigationFinal reportCessna TU206G · Eagar, AZthe pilot's failure to assure an adequate amount of fuel was on board for the flight.NTSB FTW96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Santa Fe, NMLoss of engine power for undetermined reasons. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB NYC96FA192Accident · 1 fatalField investigationFinal reportCessna 414 · Marlinton, WVThe pilot's continued VFR flight into obscured, rising mountainous terrain, and his failure to climb the airplane as conditions worsened. Factors included the rising terrain and the weather obscuration.NTSB MIA96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Cleveland, TNThe pilot's inaccurate weight and balance calculations which resulted in an over maximum allowable gross weight takeoff. Contributing to the accident was the wet, downsloping condition of the runway.NTSB LAX96LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAloss of engine power for an undetermined reason.NTSB CHI96LA047Accident · No injuriesLimited investigationFinal reportCessna 310R · Michigan City, INthe pilot-in-command's selecting and maintaining an improper approach speed.NTSB ANC96TA016Accident · No injuriesFinal reportCessna 182H · Koyuk, AKThe pilot's delayed application of carburetor heat. Factors in the accident were carburetor icing conditions and lack of suitable terrain for a forced landing.NTSB MIA96LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe student pilot's improper level-off and elevator control input.NTSB LAX96WA057Accident · No injuriesForeign investigationCessna T310R · Baja Ca Norte, MexicoNTSB FTW96LA054Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Leakey, TXimproper planning/decision by the pilot, by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion and a subsequent roll-over during a forced landing on hilly terrain. A factor relating to the accident was: downsloping terrain…NTSB ANC96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kasilof, AKThe pilot's inadvertent liftoff, and an inoperative elevator that became jammed due to frozen slush/snow.NTSB NYC96LA029Accident · Serious injuriesLimited investigationFinal reportBellanca 8-KCAB · Sheffield, MAthe pilot's inadequate preflight and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel.NTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.NTSB LAX96LA056Accident · Minor injuriesLimited investigationFinal reportMonocoupe 90A · Salinas, CAthe pilot's failure to properly recover from a slipping maneuver.NTSB LAX96LA055Accident · No injuriesLimited investigationFinal reportSchafer Lancair 360 · Mesa, AZfailure of the nose gear strut, during landing.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB FTW96LA055Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Rio Rancho, NMThe pilot's improper planning/decision. A factor relating to the accident was: the high wind condition.NTSB CHI96LA042Accident · No injuriesLimited investigationFinal reportCessna T337G · Pontiac, MIthe pilot's improper level-off and improper recovery from a bounced landing.NTSB CHI96LA039Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Stevens Point, WIflying into known icing conditions and descending below the minimum descent altitude.NTSB ATL96LA015Accident · No injuriesLimited investigationFinal reportCessna 172E · Lajas, PRthe student pilot's inadequate preflight inspection which resulted in a loss of power due to water in the fuel.NTSB SEA96LA026Accident · Serious injuriesLimited investigationFinal reportBoeing 737-522 · Portland, ORAn unexpected encounter with unforecast moderate high level windshear and turbulence as the flight attendant was performing his duties during descent.NTSB SEA96FA024Accident · 2 fatalField investigationFinal reportBeech C24R · Bozeman, MTfailure of the pilot to follow the specified approach track (proper IFR procedure), and his associated failure to maintain altitude or clearance from mountainous terrain. Factors relating to the accident were: the pilot's failure to abide by the aircraft…NTSB NYC96LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Placid, NYthe pilot's failure to maintain directional control during the landing, and subsequently the airplane veered off the runway.NTSB NYC96LA031Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lacona, NYthe pilot's inadequate preflight/planning, and his failure to remain clear of obstacles, including a tree trunk.NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB MIA96LA029Accident · 2 fatalLimited investigationFinal reportBellanca BL-17-30A · Kings Bay, GAa loss of control due to pilot spatial disorientation. Contributing to the accident was: the dark night condition and the pilot's improper decision to turn to an easterly heading with no ground reference lights available.NTSB LAX96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Sonora, CAcarburetor icing, due to the pilot's improper use of power plant controls and/or carburetor heat. A factor relating to the accident was: the weather condition, which was conducive to carburetor ice.NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.NTSB CHI96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Nora Springs, IAthe pilot's inadequate preflight planning/preparation, which resulted in loss of airspeed and a stall/mush as he was maneuvering to avoid obstructions off the end of the runway. Factors relating to the accident were: the unfavorable wind condition, high…NTSB SEA96LA023Accident · 1 fatalLimited investigationFinal reportHardesty/Hays Quickie Q2 · Puyallup, WAa loss of engine power for undetermined reasons, the pilot's failure to maintain adequate airspeed, and his improper decision to attempt a 180-degree turn back toward the runway during the forced landing.