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 ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB SEA91LA256Accident · No injuriesLimited investigationFinal reportLyons Stueckle Quickie Q-2 · Cheyenne, WYThe premature landing flare by the pilot.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.NTSB NYC91LA247Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · East Boston, MAThe malfunction of an electrical component in the cockpit, which resulted in smoke and the subsequent emergency evacuation of the passengers from the airplane.NTSB MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB MIA91FA227Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · West Palm Beach, FLThe pilot's improper use of the mixture control in that he failed to place it in full rich condition prior to takeoff. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX91LA412Accident · 2 fatalLimited investigationFinal reportChristian Ind. Eagle II · Incline Village, NVThe failure of the pilot to recover from the maneuver in a timely manner which resulted in the airplane striking the water.NTSB FTW91LA167Accident · No injuriesLimited investigationFinal reportCessna 177B · Lake Charles, LAThe pilot's failure to perform a complete preflight inspection which resulted in a total loss of engine power due to fuel exhaustion as a result of inadequate fuel supply.NTSB FTW91DPG21Accident · 1 fatalFinal reportJoseph P. Frasca Astrocraft · Johnson, ARThe loss of control for unknown reasons, and procedures for emergency equipment not followed, which resulted in parachute separation.NTSB SEA91LA257Accident · No injuriesLimited investigationFinal reportCessna 172E · Burns, ORThe pilot's delay in computing aircraft fuel consumption and his failure to land at an alternate airport along the route of flight. Factors relating to the accident were the tree by the landing area and the improper maintenance adjustment of the right magneto.NTSB NYC91LA250Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Utica, NYFatigue cracking of the propeller hub.NTSB MIA91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Atlantic Ocean (Atlantic Ocean)Total loss of engine power due to undetermined reasons.NTSB LAX91LA411Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Rio Vista, CAThe student pilot's improper use of the flight controls.NTSB LAX91LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Carlos, CAThe failure of the number 3 intake valve resulting in a total loss of engine power. A factor in this accident was the unsuitable terrain for landing the aircraft.NTSB DEN91LA134Accident · Serious injuriesLimited investigationFinal reportAbernathy LONG-EZ · Raton, NMPhysical impairment of the pilot. Factors were: rough terrain.NTSB DEN91FA135Accident · 1 fatalField investigationFinal reportCessna P210N · Pagosa Springs, COFailure of the pilot to maintain clearance from trees during an approach for a precautionary landing. His improper use of the mixture control was a related factor concerning the partial loss of engine power.NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.NTSB BFO91LA085Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Cheswold, DEThe pilot's failure to arrest an excessive sink rate and crab angle while landing his aircraft.NTSB SEA91LA253Accident · No injuriesLimited investigationFinal reportCessna 172N · Chiloquin, ORThe loss of engine power in flight due to improper maintenance inspections. A factor relating to the accident was the rough terrain at the accident site.NTSB SEA91LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Malaga, WAThe instructor pilot's failure to insure adequate terrain clearance during the go-around maneuver. Factors contributing to the accident were 1) rising terrain, 2) high density altitude condition, and 3) the instructor pilot's delay of the go-around.NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.NTSB LAX91LA407Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Livermore, CA1) Incorrect control input by the student pilot and 2) the flight instructor's inadequate supervision of his student. A contributing factor in this accident was the unfavorable wind conditions.NTSB FTW91LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Pearsall, TXThe pilot's failure to maintain adequate visual lookout for obstacles during operations from a remote site.NTSB DEN91LA133Accident · Minor injuriesLimited investigationFinal reportJoseph A. Mullan Dragon FLY · Fort Collins, COUndetermined. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB CHI91LA298Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Sunset Hills, MOA blocked fuel system line and inadequate maintenance of the airplane by other maintenance personnel.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB ATL91LA180Accident · No injuriesLimited investigationFinal reportContinental Copters MK5A · Franklin, GAAn undetermined failure of the tail rotor control cable, which resulted in an uncontrolled collision with the ground.NTSB FTW91DPG20Accident · No injuriesFinal reportAyres S2R · Dumas, ARThe failure of a worn rudder adjustment bar. A factor was the pilot's inability to maintain directional control.NTSB CHI91LA303Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Newark, ILA sheared oleo piston retaining pin which allowed the wheel to fall out.NTSB CHI91DTK04Accident · 1 fatalFinal reportBoland/Poe Tsunami · Pierre, SDA bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…NTSB ANC91LA154Accident · No injuriesLimited investigationFinal reportMaule M-5 · Purkeypile Mine, AKThe pilot's improper touchdown point on the gravel bar. Contributing to the accident was the pilot's inattentiveness and the ditch in the gravel bar.NTSB ANC91LA153Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 MKI · Holitna River, AKThe airplane's float hit a submerged log during landing on the River, which resulted in the pilot losing control of the airplane and crashing into the water.NTSB NYC91LA254Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Point Judith, RIThe pilot become disoriented and lost control of the helicopter. Contributing to the accident was a dark night, flight over water, and the pilot's lack of total flight experience.NTSB CHI91LA273Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Columbus, NEImproper refueling by ground personnel and the pilot's inadequate preflight.NTSB CHI91FA302Accident · 2 fatalField investigationFinal reportCessna A150L · Bellaire, MIThe instructor pilot's inadequate supervision which resulted in an inaverent stall and uncontrolled descent into terrain. A related factor is the insufficient altitude.NTSB SEA91LA249Accident · No injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe separation of the mixture control cable (core) resulting from separation of the adel clamp assembly and improper adjustment by maintenance personnel.NTSB LAX91LA406Accident · Serious injuriesLimited investigationFinal reportCallair A-3 · Williams, AZThe pilot's encounter with a strong and gusty cross-wind which suddenly developed in the area and his subsequent loss of control. Factors which contributed to the accident were the pilot's inadequate airspeed and inability to adequately compensate for the…NTSB CHI91LA301Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILThe flight crew's failure to maintain adequate clearance from obstacles during ground operations. A related factor is the failure of the drivers of the escort vehicle and the semi trailer to follow established procedures and directives.NTSB ANC91LA151Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Koliganek, AKThe pilot's failure to maintain airspeed. Contributing to the accident was the unfavorable wind conditions.NTSB SEA91LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lewiston, IDThe pilot's failure to maintain directional control.NTSB NYC91LA244Accident · Serious injuriesLimited investigationFinal reportCessna 170B · E. Stroudsbury, PAImproper takeoff planning by the pilot which resulted in the airplane striking trees during initial climb. A factor related to the accident was the failure of the pilot to make his departure turn in a timely manner.NTSB MIA91LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · San Sebastian, PRThe pilot in command's intentional buzzing and failure to maintain airspeed, resulting in inadvertent stall. During the uncontrolled descent, the airplane collided with and remained suspended in a tree. Contributing to the accident was the ostentatious…NTSB LAX91LA404Accident · No injuriesLimited investigationFinal reportCessna 172 · Cottonwood, AZThe pilot-in-command's delay in raising the flaps and the subsequent inadvertent stall/mush.NTSB LAX91LA403Accident · No injuriesLimited investigationFinal reportCessna 180K · Mammoth Lakes, CAThe pilot-in-command failed to maintain directional control. Contributing to this accident was the pic's lack of experience in the airplane and the soft terrain.NTSB FTW91LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Friendswood, TXThe pilot's failure to maintain directional control during landing. A factor in the accident was mechanical turbulence caused by nearby buildings.NTSB DEN91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Santa Fe, NMInadvertent deactivation of aircraft brakes by unqualified person.NTSB NYC91LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hackettstown, NJThe failure of the pilot to achieve the proper touchdown spot and excessive airspeed which resulted in an overrun. Factors related to the accident was the failure of the pilot to make a go-around after he failed to achieve his proper touchdown spot, and his…NTSB NYC91LA243Accident · No injuriesLimited investigationFinal reportLake LA-4 · Wilton, METhe pilot's improper recovery from a bounced landing on rough water which resulted in the right wing tip contacting the water causing the airplane to nose over and sink. Factors related to the accident were, the pilot's low time and experience in this type…