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 MIA99FA263Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Moreland, GAThe pilot's failure to maintain the minimum descent altitude while executing a localizer approach. Contributing factors were low ceilings and dark night conditions as well as the trees.NTSB IAD99LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Friendly, MDThe pilot's misjudgment of speed during the landing approach. The inoperative airspeed indicator was a contributing factor.NTSB CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.NTSB LAX99LA314Accident · No injuriesLimited investigationFinal reportCessna 177A · Big Bear City, CAA loss of engine power due to fuel system contamination, which resulted from the mechanic's failure to fully inspect and verify the serviceability of the fuel system before returning the aircraft to service for a maintenance ferry flight. The pilot's decision…NTSB LAX99FA315Accident · Serious injuriesField investigationFinal reportBoeing 757-2S7 · Agua Caliente, AZthe systemic failure of the airline's maintenance department to identify and correct the long standing history of intermittent faults, nuisance warnings, and erratic behavior in this airplane's GPWS system. Also causal is the airline's failure to perform the…NTSB ANC99LA156Accident · No injuriesLimited investigationFinal reportStinson 108 · Sparrevohn, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a gusting crosswind, and high vegetation.NTSB SEA99LA170Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Coolin, IDThe pilot's failure to adequately compensate for wind conditions. Factors include variable, gusty crosswinds, and trees along the sides of the runway.NTSB NYC99LA233Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Minerva, OHThe pilot's failure to maintain directional control.NTSB NYC99LA232Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT17 · Westminister, MDThe pilot's failure to maintain control of the airplane while taxiing.NTSB MIA99LA259Accident · No injuriesLimited investigationFinal reportCessna 172N · Moontown, ALThe pilot's decision to land on a runway with a quartering tailwind, his failure to obtain the proper touchdown point on the runway, and his delay in aborting the takeoff phase of a touch and go landing, resulting in the aircraft overrunning the runway,…NTSB MIA99LA258Accident · 2 fatalLimited investigationFinal reportBeech BE-200 · Atlantic Ocean (Atlantic Ocean)undetermined.NTSB LAX99LA312Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Acampo, CAThe pilot's failure to maintain runway alignment, which resulted in the aircraft encountering high vegetation, the loss of directional control, and collision with trees.NTSB IAD99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.NTSB FTW99LA263Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ozark, ARThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. A factor was the wet grass runway.NTSB FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.NTSB DEN99LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rifle, COThe pilot's failure to maintain aircraft control during landing roll. Factors were the strong crosswind weather conditions, and the runway sign that the airplane impacted.NTSB DEN99LA166Accident · No injuriesLimited investigationFinal reportCessna 172G · Delta, COA forced landing due to fuel exhaustion. Factors were inadequate preflight planing, inadequate in-flight planing and rough uneven, unsuitable terrain for a forced landing.NTSB CHI99LA344Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Atlanta, KSthe pilots failure to maintain control of the aircraft. Factors were the aerobatic maneuvers performed by the pilot and the low altitude.NTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.NTSB ATL99FA134Accident · 2 fatalField investigationFinal reportBeech BE-35-J35 · Bartow, FLThe pilot's inadequate fuel management that resulted in the complete loss of engine power.NTSB ANC99LA149Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a windshear, and a short runway area.NTSB ANC99LA147Accident · No injuriesLimited investigationFinal reportCessna 185F · Pilot Point, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the pilot's inadequate evaluation of the weather conditions, a downdraft, and swampy terrain.NTSB SEA99LA167Accident · No injuriesLimited investigationFinal reportCessna 182S · Kamiah, IDThe pilot's excessive airspeed on final approach, his inadequate remedial action, and his failure to attain the proper touchdown point during landing. Factors included a short, confined landing area and a tailwind.NTSB SEA99LA166Accident · 1 fatalLimited investigationFinal reportPitts 11 · Iona, IDThe pilot-in-command's delayed recovery from a snap roll. A contributing factor was the low altitude at which the maneuver was initiated.NTSB NYC99LA230Accident · No injuriesLimited investigationFinal reportCessna 182 · Pepperell, MAA landing gear bolt failure for undetermined reasons.NTSB NYC99LA229Accident · No injuriesLimited investigationFinal reportCessna 305A · Warehouse Point, CTThe pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.NTSB NYC99IA231Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYDeteriorated wire insulation and shorting at a short radius bend to the electrical wiring in the right side alternate static port heater, which resulted in electrical arcing and a fire sustained by overlaying thermal acoustic insulation.NTSB LAX99LA319Accident · No injuriesLimited investigationFinal reportBell OH58A · Salinas, CAThe pilot's failure to maintain an adequate clearance from all ground obstacles during a low altitude aerial application flight.NTSB LAX99FA316Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · June Lake, CAThe pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.NTSB LAX99FA311Accident · 1 fatalField investigationFinal reportNo American/Rogers B L P-51R · Reno, NVThe onset of a flutter event and the resultant separation of the rudder and empennage from the aircraft. The precipitating cause for the flutter could not be determined.NTSB FTW99FA261Accident · 5 fatalField investigationFinal reportCessna 182A · Bryan, TXthe pilot's failure to maintain aircraft control resulting in an inadvertent stall. A factor was the loss of engine power as a result of fatigue cracking and separation of the #6 cylinder head.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB DEN99LA163Accident · No injuriesLimited investigationFinal reportRobinson R22A · Tucumcari, NMThe pilot's inadequate visual lookout. A factor was a reduced visual detection due to background vegetation and terrain.NTSB DCA99WA085Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Shannon, IrelandNTSB CHI99LA345Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Troy, MOthe failure of the pilot to maintain directional control during landing. Factors in the accident were the proper alignment not attained by the pilot and the trees.NTSB ANC99LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's choice of unsuitable terrain for taxi, and inadequate compensation for high winds. Factors associated with this accident were the muddy ground, and the winds of 25 knots gusting to 40 knots.NTSB SEA99LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Eatonville, WAInadequate inflight planning/preparation and terrain clearance not maintained. Mountainous terrain, cloudy conditions and delayed remedial action are factorsNTSB MIA99WA260Accident · 6 fatalForeign investigationAero Commander 500S · La Tinta, GuatemalaNTSB LAX99LA323Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Beatty, NVthe failure of the injured passengers to remain seated with their seat belts fastened as directed by the captain.NTSB LAX99LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Merced, CAThe pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB ANC99LA153Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain a visual lookout for a parked airplane during taxi.NTSB SEA99LA164Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crescent Lake, ORThe pilot's failure to maintain directional control during a bounced landing. Factors include a sudden wind shift, a crosswind gust, and tall trees growing along the side of the airstrip.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB CHI99FA343Accident · 1 fatalField investigationFinal reportPiper J-3 · Brookville, OHthe stall/spin encountered by the pilot. A factor was the intentional slow flight.NTSB CHI99FA341Accident · 3 fatalField investigationFinal reportCessna 172H · Plattsburg, MOthe pilot's failure to maintain airspeed during the initial climb. A factor relating to this accident was the inadvertent stall/spin.NTSB ATL99FA132Accident · 2 fatalField investigationFinal reportContinental Copters Tomcat MK5A · Heflin, ALThe pilot of N9010T's failure to maintain visual lookout while maneuvering, resulting in a midair collision with N30899. A factor was the sun glare.NTSB SEA99LA162Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Burley, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a taxiway marking sign located adjacent to the runway.NTSB LAX99TA308Accident · No injuriesFinal reportCessna A185F · Daggett, CAthe pilot's failure to recognize an excessive rate of descent and his subsequent delayed flare, which resulted in a hard landing.