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 IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.NTSB FTW96IA235Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Childress, TXThe aircraft's encounter with unforcasted and unreported severe turbulence.NTSB CHI96LA189Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, MIforeign material, probably due to improper maintenance, which blocked the main fuel metering jet of the carburetor, and resulted in fuel starvation and loss of engine power.NTSB CHI96FA185Accident · 1 fatalField investigationFinal reportCorey Cirrus VK-30 · Lapeer, MIincomplete cure of the bonding material in the cruise flap, improper material in the cruise flap hinge, and improper welding of the cruise flap push rod end caps. Factors were delamination of the cruise flap, partial failure of the cruise flap hinge, and…NTSB SEA96LA109Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Richland, WAthe pilot's failure to perform a go-around and his subsequent excessive use of the aircraft brakes. The short airstrip length and the pilot's excessive airspeed for the approach were related factors.NTSB MIA96IA146Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Miami, FLfatigue failure of a segment of the elevator trim cable.NTSB LAX96LA215Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Sonora, CAfailure of the number 1 connecting rod due to oil starvation caused by inadequate bearing crush.NTSB IAD96LA088Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Oakwood, OHa loss of engine power due to inadequate maintenance and inspection by the owner/operator which failed to detect the clogged fuel vent line, and the pilot's improper autorotation. A related factor was the pilot's inadequate training/familiarization with…NTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB CHI96FA184Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · Aitkin, MNthe pilot's continued flight into known adverse weather conditions and the pilot exceeding the design stress limits of the airplane. Factors contributing to this accident were: the thunderstorms, hail, and wind gusts, and the airplane's over maximum gross…NTSB SEA96LA110Accident · No injuriesLimited investigationFinal reportStelly Kolb Firestar II · Independence, ORfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.NTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.NTSB NYC96LA119Accident · No injuriesLimited investigationFinal reportCessna 172F · Blairstown, NJthe pilot's failure to maintain directional control due to improper compensation for wind conditions.NTSB NYC96LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Williamstown, NJinadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.NTSB LAX96LA217Accident · No injuriesLimited investigationFinal reportHughes 269B · Georgetown, CAloss of engine power for undetermined reason(s), while practicing an autorotation, which resulted in a forced landing; and the flight instructor's misjudged landing flare during the emergency autorotation/landing.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB ANC96IA077Incident · No injuriesIncident investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were: soft terrain, the use of an oversize nose wheel tire, and the FAA's inadequate field approval process for tundra tires.NTSB SEA96LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Seattle, WAAn intentional plan or decision by the pilot to ditch the airplane in Puget Sound.NTSB SEA96LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Arock, ORthe pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.NTSB SEA96LA105Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Puyallup, WAthe pilot's improper recovery from a bounced landing, and failure to maintain runway alignment during a go-around. The pilot's improper flare for landing was a related factor.NTSB MIA96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barbour Island, GAthe pilot's failure to adequately compensate for gusty wind conditions.NTSB MIA96LA144Accident · No injuriesLimited investigationFinal reportBell UH1B · West Palm Beach, FLthe failure of the tail rotor drive shaft which resulted in a loss of tail rotor control.NTSB LAX96LA216Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Eureka, NVa loss of engine power for undetermined nonmechanical reasons. A contributing factor was the lack of suitable terrain for use during an aborted takeoff.NTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.NTSB FTW96LA232Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARfailure of the pilot to maintain clearance from the power line.NTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.NTSB CHI96LA188Accident · 1 fatalLimited investigationFinal reportGray Miniplane DSA-1-G · Astoria, ILthe pilot's failure to maintain clearance with the terrain while performing an aerobatic maneuver.NTSB CHI96LA182Accident · No injuriesLimited investigationFinal reportMooney M20F · Festus, MOthe pilot's not maintaining proper alignment with the runway and his inadequate compensation for wind conditions. A factor was the crosswind condition.NTSB SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.NTSB LAX96LA214Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Corning, CAthe pilot misjudged the airplane's clearance from wires he was flying beneath. A contributing factor was the presence of light turbulence.NTSB LAX96LA213Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lost Hills, CAthe loss of engine power due to a cylinder failure. A contributing factor was the lack of a suitable field for the forced landing.NTSB FTW96LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Longview, TXan improper flare by the pilot rated student, while landing with a tailwind; and inadequate supervision by the flight instructor.NTSB CHI96LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIthe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. Factors associated with the accident were the misjudged landing flare and the raised taxiway edge which the airplane contacted.NTSB CHI96LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIthe flight instructor's inadequate supervision. A factor relating to the accident was: the student pilot's improper flare.NTSB CHI96FA179Accident · 1 fatalField investigationFinal reportDotson Seabird · Geneseo, ILa loos of power due to a blocked fuel line and the pilot's failure to maintain airspeed.NTSB ATL96LA089Accident · No injuriesLimited investigationFinal reportSchweizer SGS233A · Franklinton, NCthe failure of the instructor pilot to maintain control of the aircraft.NTSB SEA96LA103Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Moscow, IDinflight loss of an unsecured access plug from the engine crankcase, which resulted in a loss of engine oil and a forced landing. Factors relating to the accident were: hilly terrain, and foreign material (engine oil) on the windscreen which limited forward…NTSB SEA96IA104Incident · No injuriesIncident investigationFinal reportDornier 328 · Billings, MTpaint overspray on the elevator trim actuator push rods, which damaged the actuator quad rings during normal operation and allowed water to enter the actuators; and the resultant freezing of the actuators. Factors relating to the incident included the…NTSB FTW96FA230Accident · 5 fatalField investigationFinal reportPiper PA-31T · Malvern, ARThe pilot's failure to maintain control of the airplane after takeoff.NTSB CHI96LA181Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Des Moines, IAthe pilot's inadvertent use of the brakes which resulted in a loss of directional control. A factor associated with the accident was the ravine which the airplane traveled down.NTSB ATL96LA088Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Jesup, GAthe pilot's inadequate preflight planning/preparation, and his failure to remain clear of the fence during takeoff.NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…NTSB NYC96IA116Incident · No injuriesIncident investigationFinal reportBoeing 767-31AER · Boston, MANumerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.NTSB LAX96LA212Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Sparks, NVthe pilot's inadequate compensation for wind conditions during the takeoff roll, and his failure to maintain control of the glider. The gusty wind condition was a related factor.NTSB LAX96LA208Accident · No injuriesLimited investigationFinal reportBoeing B75-A75N1 · Page, AZthe pilot's improper flare, improper recovery from a bounced landing, inadequate compensation for wind conditions, and failure to maintain directional control of the airplane, while landing in gusty/crosswind conditions. The gusty, crosswind condition was a…NTSB LAX96LA207Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Thermal, CAinadequate design of the stress limits for cyclic control of the helicopter.NTSB FTW96FA228Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Lake Providence, LAfailure of the pilot to maintain sufficient airspeed, while maneuvering (turning), which resulted in an inadvertent stall and collision with the terrain. The high gusty wind condition was a related factor.NTSB CHI96LA177Accident · No injuriesLimited investigationFinal reportCessna U206 · Inver Grove, MNthe pilot's improper recovery from the bounced landing. The gusty wind condition was a factor.NTSB CHI96LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Wichita, KSthe pilot's failure to maintain directional control of the airplane during landing. A factor associated with the accident was the gusty crosswind condition.