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 SEA96LA191Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lander, WYthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors relating to the accident were: the variable and gusty wind conditions.NTSB LAX96LA312Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Vacaville, CAThe pilot's failure to maintain directional control of the aircraft during the landing rollout.NTSB LAX96LA309Accident · No injuriesLimited investigationFinal reportCessna 195A · San Luis Obispo, CAthe pilot's failure to maintain directional control, which resulted in a ground loop/swerve.NTSB FTW96LA351Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Midland, TXfailure of the pilot to obtain or maintain adequate airspeed, by allowing the airplane to enter an excessive nose high attitude and an excessive rate of climb after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain. A…NTSB CHI96TA306Accident · Minor injuriesFinal reportHughes 269A · Cedar Rapids, IApartial blocking of the fuel injection control, and a fracture of the induction air ducting for reasons undetermined. A factor was trees.NTSB CHI96LA307Accident · No injuriesLimited investigationFinal reportCessna 180 · Duxbury, MNthe failure of the pilot to maintain airspeed.NTSB CHI96FA309Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Crystal Lake, ILthe pilot's inadequate fuel management and which resulted in fuel system exhaustion. The factors involved were the pilot's failure to refuel, inadequate preflight planning/preparation and the dark night conditions encountered.NTSB CHI96FA301Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Hinckley, ILthe instructor pilot exceeded the design stress limits of the aircraft which resulted in the overload failure of the wing. A factor was that the weight and balance of the aircraft was exceeded by the instructor pilot.NTSB SEA96LA195Accident · No injuriesLimited investigationFinal reportCessna 182E · Grangeville, IDfailure of the pilot to maintain proper runway alignment and clearance from a fence post during landing. Factors relating to the accident were: an animal (deer) on the approach end of the runway, an encounter with a downdraft, and a fence post near the edge…NTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).NTSB IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.NTSB FTW96LA354Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Victoria, TXthe pilot's failure to maintain directional control of the airplane during the landing roll. A related factor was the rough/uneven terrain (gopher mound) on the grass runway.NTSB FTW96LA350Accident · Minor injuriesLimited investigationFinal reportHardy Quickie Q-200 · Hudson, COdelamination of a propeller blade. A factor relating to the accident was: the terrain condition in the emergency landing area (soft/sandy berm and ditch).NTSB CHI96LA305Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Shakopee, MNfailure of the right main landing gear shock strut due to internal corrosion. The restriction to inspection of the strut was a related factor.NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB ANC96LA128Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKthe pilot's delayed in initiating a go-around, and his failure to maintain clearance from trees. The high/fast approach for landing was a related factor.NTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.NTSB NYC96LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tafton, PAThe pilot's misjudgment of speed and distance during the landing.NTSB LAX96LA311Accident · No injuriesLimited investigationFinal reportAtkinson Varieze · Glendale, AZThe fracture and separation of the mixture control cable housing from the carburetor mounting bracket, which resulted in fuel starvation due to an overlean condition, and the pilot's failure to maintain an adequate airspeed while stretching the glide to the…NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.NTSB FTW96LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXfailure of the pilot to maintain directional control of the airplane during a touch-and-go, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over of the airplane.NTSB FTW96LA349Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · W. Helena, ARThe inadequate visual lookout of the vehicle driver and his inadvertent driving of the vehicle onto the runway resulting in the pilot of the departing aircraft performing an evasive maneuver in an attempt to avoid the collision.NTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.NTSB CHI96LA302Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenwood, ILthe pilot's failure to obtain a proper touchdown point.NTSB ATL96LA120Accident · No injuriesLimited investigationFinal reportGreat Lakes GL2T-1A-2 · Montgomery, ALThe locked rudder in a fully deflected position which resulted in the pilot's inability to maintain directional control.NTSB ATL96FA119Accident · 1 fatalField investigationFinal reportCessna 172H · St. Petersburg, FLAn engine malfunction for undetermined reasons. A factor was the pilot's selection of an unsuitable landing site.NTSB ANC96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dillingham, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain was a factor in the accidentNTSB NYC96IA169Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Howard Beach, NYfatigue failure of the fore flap attachment fitting, due to grinding marks on the fitting.NTSB MIA96LA214Accident · No injuriesLimited investigationFinal reportCessna 150F · Plant City, FLa loss of engine power due to fuel contamination, resulting in a forced landing, and subsequent nose over. A factor in this accident was an inadequate aircraft pre-flightNTSB FTW96LA348Accident · Minor injuriesLimited investigationFinal reportVans RV-4 · Van Horn, TXloss of engine power due to a cracked oil cooler, which led to the loss of all lubricating oil and an engine seizure. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.NTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.NTSB ANC96LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to maintain directional control during takeoff. A factor associated with the accident was the rough and uneven terrain.NTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.NTSB SEA96LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Paterson, WAfailure of the student pilot to maintain directional control of the airplane during a landing, which resulted in an uncontrolled ground loop/swerve. Factors relating to the accident were: the gusty crosswind condition, and soft terrain beside the runway.NTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.NTSB MIA96WA230Accident · 8 fatalForeign investigationBell UH-1B · Concepcion, ArgentinaNTSB MIA96LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and the nose gear collapsing.NTSB IAD96LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Hanover, PAthe pilot's delay in aborting the landing. Factors related to the accident were: the lack of braking action on the wet grass runway, the pilot's lack of experience in the make and model of airplane, and the sign near the departure end of the runway.NTSB IAD96FA136Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elkton, MDThe pilot's failure to maintain adequate altitude and control of the airplane while performing aerobatic maneuvers.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB CHI96LA295Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Custer, SDloss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.NTSB NYC96IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Flushing, NYa failure of the low pressure turbine assembly for undetermined reason(s).NTSB LAX96LA306Accident · Minor injuriesLimited investigationFinal reportCessna 172Q · Kayenta, AZthe pilot's failure to adhere to the manufacturer's performance data by not maintaining the recommended best rate of climb speed, resulting in an inadvertent stall/mush event. The high density altitude was a related factor.NTSB IAD96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pottstown, PAThe pilot's failure to maintain directional control during takeoff/ground run resulting in in-flight collision with a fence. Related factors were the pilot's poor planning/decision making, and the fog.NTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.NTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB CHI96LA294Accident · Serious injuriesLimited investigationFinal reportCameron CIGPACK-80 · Columbia, MOfailure of the pilot to see-and-avoid transmission (power) lines during the landing. Factors relating to the accident were: vegetation and trees, which obscured the pilot's view of the power lines.NTSB ANC96LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAn engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.