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 FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.NTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.NTSB NYC96LA148Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Westerly, RIinsufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…NTSB IAD96LA118Accident · No injuriesLimited investigationFinal reportCessna 172 · Frederick, MDthe private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.NTSB IAD96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Blue Ash, OHfailure of the pilot to maintain directional control of the airplane, while rolling to takeoff from a touch-and-go landing.NTSB FTW96LA306Accident · No injuriesLimited investigationFinal reportSmith RV4 · Mandeville, ARa loss of engine power for undetermined reasons.NTSB CHI96LA243Accident · No injuriesLimited investigationFinal reportBeech C-45H · Marshall, MIfailure of the pilot to maintain directional control during the takeoff roll, which resulted in an inadvertent ground swerve. The crosswind (quartering headwind) was a related factor.NTSB CHI96LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lafeyette, INthe pilot's failure to maintain directional control during landing. Factors related to the accident were the pilot's inadequate compensation for the wind conditions and the crosswind.NTSB ATL96LA107Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Scotia, SCa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for a forced landing.NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.NTSB SEA96LA154Accident · Minor injuriesLimited investigationFinal reportColonial C-1 · Halls Crossing, UTthe pilot's inadequate preflight of the airplane, and subsequent fuel exhaustion due to an inadequate supply of fuel, which resulted in loss of engine power and an emergency landing. Uneven terrain in the emergency landing area was a related factor.NTSB NYC96WA175Accident · 2 fatalForeign investigationPiper PA-30 · North Italy, ItalyNTSB NYC96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Fairfield, NJthe pilot's improper aborted takeoff by extending full flaps which resulted in a porpoise. Subsequently, the airplane veered off the runway and the nose gear collapsed.NTSB MIA96LA183Accident · No injuriesLimited investigationFinal reportRockwell S2R · Belzoni, MSfatigue failure of the #5 cylinder skirt, which resulted in debris that caused the oil scavenge pump to fail, oil starvation, cam drive seizure, loss of engine power, and a subsequent forced landing in a field of cotton.NTSB LAX96LA347Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Palm Springs, CAthe failure of a propeller blade as a result of undetected in-service mechanical damage that caused a stress point that progressed to a point of failure.NTSB LAX96LA271Accident · No injuriesLimited investigationFinal reportCessna 180 · Thermal, CAThe pilot's inadequate compensation for the existing wind conditions.NTSB LAX96LA270Accident · No injuriesLimited investigationFinal reportCessna 177RG · Folsom, CAAn oil starvation failure of the engine due to a mechanic's failure to put the proper gasket stack on when the propeller governor was replaced. The mechanic's omission was due to the airframe manufacturer's failure to ensure that the service and parts manuals…NTSB IAD96LA116Accident · 1 fatalLimited investigationFinal reportQuicksilver Sprint · Mt Airy, MDThe pilot's improper planning/decision and exceeding the design stress limits of the aircraft, which resulted in overload failure of the wing and subsequent uncontrolled collision with the terrain. Factors related to the accident were: the pilot's failure to…NTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.NTSB CHI96LA240Accident · Minor injuriesLimited investigationFinal reportSauder Avid Flyer HH · Stoneville, SDloss of engine power for undetermined reason(s). A factor relating to the accident was: rough/uneven terrain in the emergency landing area.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB ATL96LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Hickory, NCEngine stoppage for undetermined reasons. A factor was the terrain furrows.NTSB ANC96LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's failure to maintain directional control while landing.NTSB ANC96FA098Accident · 1 fatalField investigationFinal reportSikorsky CH-54A · Ketchikan, AKfailure of the number 5 tailrotor bearing. A factor relating to the accident was: the uneven/steep sloping terrain, where the pilot was forced to land. Possible factors were: inadequate handling/labeling of the 'relubed' bearing by intermediate supplyier(s),…NTSB SEA96LA156Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Arock, ORfailure of the pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground loop. The tailwind was a related factor.NTSB SEA96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Lewistown, MTthe pilot's inadequate compensation for the changing wind conditions, and his failure to maintain directional control, which resulted in an inadvertent ground swerve. The sudden windshift was a related factor.NTSB NYC96LA147Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Rockaway, NJThe pilot's impairment of judgment and performance due to alcohol which led to his inadequate preflight of the aircraft and his inadequate inflight decision which resulted in fuel exhaustion and loss of engine power.NTSB MIA96LA189Accident · No injuriesLimited investigationFinal reportPitts S-2B · Boca Raton, FLthe dual student's inadequate compensation for wind conditions, and inadequate supervision by the flight instructor. The gusty/crosswind condition was a related factor.NTSB MIA96LA182Accident · Serious injuriesLimited investigationFinal reportTocholke 1300-Z MAX · Lascassas, TNfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) after takeoff, which resulted in an inadvertent stall at too low of an altitude to allow recovery.NTSB IAD96LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Hartford, CTthe pilot's inadequate preflight planning/preparation, and his failure to attain the proper lift-off airspeed, which resulted in a stall and collision with the terrain (river).NTSB CHI96LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Parker, SDengine compartment fire from accumulated fuel in the carburetor, and failure of the pilot to follow the emergency checklist procedure.NTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.NTSB NYC96LA150Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Providence, RIthe passenger inadvertently lost his balance and fell, while deplaning.NTSB MIA96LA180Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pigeon Forge, TNfatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.NTSB IAD96LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salisbury, MDthe student pilot's failure to maintain directional control during the takeoff roll.NTSB FTW96LA299Accident · No injuriesLimited investigationFinal reportBell 206B · Matagorda, TXThe loss of engine power due to fuel system contamination. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB CHI96LA234Accident · No injuriesLimited investigationFinal reportCessna 172L · Vicksburg, MIthe pilot's premature raising of the flaps during a go-around. The presence of birds was a factor.NTSB ATL96LA104Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cottondale, FLfailure of the main rotor drive torsional coupling and inner gimbal ring, which resulted in jamming of the flight controls during an attempted autorotation.NTSB SEA96LA151Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Stanley, IDthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The crosswind was a related factor.NTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.NTSB MIA96LA178Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.NTSB IAD96LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Vincent, OHthe instructor's inadequate supervision by allowing the student and himself to become lost, his inadequate inflight planning/decision by failing to ensure the airplane was safely landed before fuel was exhausted, and his selection of unsuitable terrain for a…NTSB IAD96LA110Accident · No injuriesLimited investigationFinal reportMooney M20M · Hartford, CTthe pilot's inadequate control of the airplane during the approach to landing/landing roll. A related factor is the pilot's inadequate remedial action (attempted go-around).NTSB FTW96LA297Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Mcgehee, ARa loss of engine power and subsequent engine fire for undetermined reasons.NTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.NTSB CHI96LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Freeport, ILThe pilot's misjudgment of altitude and distance on final approach, and his failure to attain the proper touchdown point for landing.NTSB CHI96LA232Accident · No injuriesLimited investigationFinal reportCessna 188 · Independence, IAthe delayed jettison of the dry chemicals by the pilot. The inability of the airplane to climb was a related factor.NTSB SEA96LA148Accident · Serious injuriesLimited investigationFinal reportMooney M18LA · Beaver Marsh, ORthe loss of engine power for undetermined reason(s). A factor relating to the accident was: the presence of trees near the forced landing area.NTSB MIA96IA179Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60-200 · San Juan, PRFatigue failure of a segment of the elevator trim control cable. Contributing to the accident was the failure of the airplane manufacturer to require a replacement interval of the cables.