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.

NTSB MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.Nov 20, 1999 · N475ER · Substantial damageNTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.Nov 20, 1999 · N413JF · Substantial damageNTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.Nov 20, 1999 · N8825P · DestroyedNTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.Nov 19, 1999 · N5203M · Substantial damageNTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.Nov 19, 1999 · N6199G · Substantial damageNTSB LAX00LA036Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Petaluma, CAThe failure of the pilot to maintain adequate airspeed which resulted in a stall/mush condition and subsequent hard landing.Nov 19, 1999 · N550RT · Substantial damageNTSB FTW00LA034Accident · No injuriesLimited investigationFinal reportCessna 150M · Carrolton, TXThe pilot's failure to refuel, which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 19, 1999 · N63077 · Substantial damageNTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.Nov 18, 1999 · N317RS · Substantial damageNTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.Nov 17, 1999 · N519EH · Substantial damageNTSB SEA00FA021Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Seattle, WAAdequate separation and lookout not maintained by the pilots of both aircraft.Nov 17, 1999 · N206AC · 2 aircraft · Substantial damageNTSB LAX00LA034Accident · Serious injuriesLimited investigationFinal reportHawker Siddeley Hunter T MK 7 · Mesa, AZThe fatigue failure and separation the stage 3 compressor blades due to corrosion pitting of the blade retention lug bores. A factor in the accident was the failure of the various post military surplus operators of this engine to incorporate the…Nov 17, 1999 · N576NL · Substantial damageNTSB FTW00LA033Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lafayette, LAThe partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…Nov 17, 1999 · N4803U · Substantial damageNTSB DEN00LA019Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · El Paso, TXAn uncommanded flight control input for undetermined reasons resulting in rotor blade contact with the ground and subsequent loss of control.Nov 17, 1999 · N341G · Substantial damageNTSB CHI00LA031Accident · No injuriesLimited investigationFinal reportCessna 182 · Shelbyville, INthe inadequate preflight planning by the pilot and the exhaustion of usable fuel. A factor was the drainage ditch encountered on landing.Nov 16, 1999 · N5388B · Substantial damageNTSB ANC00LA015Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Dillingham, AKFailure of the pilot to remove frost from the wings prior to flight, and the resulting inadvertent stall/mush.Nov 16, 1999 · N9933M · Substantial damageNTSB MIA00LA025Accident · 1 fatalLimited investigationFinal reportFrederick Rocket II · Coral Springs, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent stall and subsequent in-flight collision with water. Contributing to the accident was the pilot's improper fuel management resulting in a total loss of engine power…Nov 15, 1999 · N561L · DestroyedNTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.Nov 15, 1999 · N738NL · Substantial damageNTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.Nov 15, 1999 · N4UE · Substantial damageNTSB ANC00LA013Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Palmer, AKThe pilot's intentional takeoff into known adverse weather. Factors associated with this accident are crosswinds, gusts, and downdrafts.Nov 15, 1999 · N5657A · Substantial damageNTSB ATL00LA013Accident · No injuriesLimited investigationFinal reportBeech BE36 · Daytona Beach, FLThe collapse of the main landing gear for undetermined reasons.Nov 14, 1999 · N3089A · Substantial damageNTSB SEA00LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · Garden Valley, IDAn improper in-flight decision by the pilot-in-command to attempt a landing at a confined-area airstrip which was beyond his piloting capabilities, and his subsequent failure to take adequate remedial action upon encountering a downdraft. Related factors were…Nov 13, 1999 · N7164M · Substantial damageNTSB SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…Nov 13, 1999 · N82553 · DestroyedNTSB NYC00LA033Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Fayetteville, WVThe pilot's decision to continue the landing attempt too far down the runway. A factor was the pilot's self-induced pressure to land the airplane, due to the sickness of the front seat passenger.Nov 13, 1999 · N4542P · DestroyedNTSB LAX00LA035Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Van Nuys, CAThe pilot's encounter with unknown and unanticipated wake turbulence from a heavy transport aircraft, which was landing at another airport. A factor in the accident was the tower controller's failure to repeat a previously broadcast wake turbulence cautionary…Nov 13, 1999 · N1195L · Substantial damageNTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.Nov 13, 1999 · N4046M · Substantial damageNTSB CHI00LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-34 · East Lynne, MOinadequate airspeed and a subsequent stall. Factors associated with the accident were the tailwind, the pilot's misjudgment of the wind condition, and poor inflight planning.Nov 13, 1999 · N7646 · Substantial damageNTSB ATL00LA014Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ridgeland, SCThe pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.Nov 13, 1999 · N2570F · Substantial damageNTSB IAD00LA005Accident · No injuriesLimited investigationFinal reportAnkenbruck SEA Hawk · Somerset, PAThe pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.Nov 12, 1999 · N101WR · Substantial damageNTSB DEN00LA018Accident · No injuriesLimited investigationFinal reportCessna 172N · Rawlins, WYThe pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.Nov 12, 1999 · N5225D · Substantial damageNTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.Nov 12, 1999 · N427ES · Substantial damageNTSB DCA00WA011Incident · No injuriesForeign investigationBritish Aerospace BAe-146 · Malmo, SwedenNov 12, 1999 · SEDRE · No damageNTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.Nov 12, 1999 · N6533E · DestroyedNTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.Nov 12, 1999 · N869 · DestroyedNTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.Nov 11, 1999 · N6245E · Substantial damageNTSB SEA00IA019Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Portland, ORArcing in the electrical system wiring for undetermined reasons.Nov 11, 1999 · N772AS · Minor damageNTSB LAX00LA032Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, CAThe pilot's failure to maintain directional control of the airplane during the touch-and-go takeoff.Nov 11, 1999 · N183DA · Substantial damageNTSB FTW00LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rose Hill, TXThe pilot's failure to maintain directional control during takeoff roll, which resulted in an inadvertent ground loop.Nov 11, 1999 · N3311B · Substantial damageNTSB CHI00LA028Accident · Serious injuriesLimited investigationFinal reportShaffer Evans Volksplane · Stanley, NDrefueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.Nov 11, 1999 · N78VS · Substantial damageNTSB FTW00RA029Accident · 18 fatalForeign investigationDouglas DC-9-31 · Uruapan, MexicoNov 10, 1999 · XATKNNTSB DEN00FA135Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Lake City, COthe pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…Nov 10, 1999 · N6691V · DestroyedNTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.Nov 10, 1999 · N9627C · Substantial damageNTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.Nov 10, 1999 · N55035 · Substantial damageNTSB ATL00LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Jacksonville, FLThe failure of the left main landing gear down locking mechanism for undetermined reasons.Nov 10, 1999 · N310GC · Substantial damageNTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.Nov 9, 1999 · N8323G · Substantial damageNTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…Nov 9, 1999 · N93688 · Substantial damageNTSB MIA00WA024Accident · 4 fatalForeign investigationBeech 58 · Abidjan, MaliNov 9, 1999 · TUTMP · DestroyedNTSB DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.Nov 9, 1999 · N457DA · Minor damageNTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.Nov 8, 1999 · N7783A · Substantial damageNTSB MIA00LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Olive Branch, MSThe private-rated student pilots inadvertent retraction of the main landing gear during a touch-and-go landing. Contributing to the accident was the flight instructors improper supervision of the dual student.Nov 8, 1999 · N56676 · Substantial damageNTSB LAX00FA041Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30F · Honolulu, HIThe pilot-in-command initiated an evasive manuver during a near midair collission. The airplane entered a prestall buffet, which resulted in buckling of the elevator skins.Nov 8, 1999 · N602GC · Substantial damage