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 SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…Dec 29, 1994 · N24741 · Substantial damageNTSB LAX95LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-161 · Elko, NVThe pilot selected unsuitable terrain for takeoff.Dec 29, 1994 · N2269Z · Substantial damageNTSB LAX95LA064Accident · No injuriesLimited investigationFinal reportRockwell S2R Thrush Cmdr · Yuma, AZa forced landing due to an engine failure of the no.1 cylinder.Dec 29, 1994 · N8455V · Substantial damageNTSB LAX95LA063Accident · 2 fatalLimited investigationFinal reportMcDonnell Douglas 500 · Chuuk Island (Pacific Ocean)undetermined.Dec 29, 1994 · N9128F · DestroyedNTSB FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.Dec 29, 1994 · N737ZJ · Substantial damageNTSB DCA95WA012Accident · No injuriesForeign investigationBoeing 737-400 · Van, TürkiyeDec 29, 1994 · TCJES · DestroyedNTSB CHI95LA064Accident · Minor injuriesLimited investigationFinal reportNorth American F-51D · Round Lake, ILfuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.Dec 29, 1994 · N51TK · Substantial damageNTSB SEA95LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Murphy, IDThe pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.Dec 28, 1994 · N9107X · DestroyedNTSB NYC95DNC01Accident · No injuriesFinal reportWyman Scorpion II · Cornish Flat, NHPartial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.Dec 28, 1994 · N65562 · DestroyedNTSB MIA95FA042Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Plant City, FLThe opening of the engine cowling latch in cruise flight for undetermined reasons. This resulted in the puncture of the engine oil cooler, total exhaustion of the engine oil, failure of the No. 6 connecting rod, rod bolts, forced landing while on final…Dec 28, 1994 · N33456 · DestroyedNTSB LAX95FA062Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Holtville, CAthe pilot's becoming lost/disoriented during a night cross- country flight at a time the flight was in a critical low fuel state, and his failure to maintain aircraft control during a go-around from an aborted precautionary landing. Factors in the accident…Dec 28, 1994 · N4647R · DestroyedNTSB CHI95LA063Accident · Minor injuriesLimited investigationFinal reportHoover Bushby MM1 · Chesterfield, MOthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of recent total experience.Dec 28, 1994 · N32VF · Substantial damageNTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…Dec 28, 1994 · N3983H · Substantial damageNTSB SEA95LA032Accident · Minor injuriesLimited investigationFinal reportPitts S-2B · Afton, WYThe pilot's failure to maintain directional control, and his inadequate remedial action. Factors include snow covered terrain at the edge of the runway.Dec 27, 1994 · N60823 · Substantial damageNTSB NYC95LA047Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Lancaster, NYThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel to return to the home airport after proceeding to an alternate airport and making a missed approach. Factors related to the accident were:…Dec 27, 1994 · N9457L · Substantial damageNTSB NYC95LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Huber Heights, OHThe pilot's inadequate inflight decision/planning, which resulted in fuel exhaustion and the loss of engine power. A factor is the pilot's inadequate preflight planning.Dec 27, 1994 · N201JT · Substantial damageNTSB LAX95LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · North Las Vegas, NVthe pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.Dec 27, 1994 · N7446G · Substantial damageNTSB FTW95LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Monahans, TXThe pilot's failure to use the carburetor heat and failure to maintain airspeed. A factor was the icing conditions.Dec 27, 1994 · N6417S · DestroyedNTSB FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.Dec 27, 1994 · N8112P · DestroyedNTSB BFO95LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDSeparation of the steering linkages on the nosegear which resulted in the pilot being unable to maintain directional control during landing and subsequent on ground collision with a ditch.Dec 27, 1994 · N93042 · Substantial damageNTSB MIA95LA050Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Arcadia, FLPoor in flight planning/decision by the pilot for electing to land with fog on the airstrip. Contributing to the accident was failure of the pilot to obtain a formal preflight weather briefing and his failure to fully apply the brakes (normal) after landing.…Dec 26, 1994 · N546V · Substantial damageNTSB ANC95LA022Accident · No injuriesLimited investigationFinal reportCessna 140 · Tok, AKThe pilot's attempt to fly into known adverse weather. A factor related to the accident was the icing conditions.Dec 26, 1994 · N89870 · Substantial damageNTSB MIA95FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Missing, FLUndetermined.Dec 25, 1994 · N5916V · DestroyedNTSB BFO95IA023Incident · No injuriesIncident investigationFinal reportDouglas DC-8-54F · New York, NYThe failure of the right main landing gear's shock strut piston lug due to stress corrosion.Dec 25, 1994 · N427FB · Minor damageNTSB ANC95LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Unalakleet, AKThe pilot's inadequate compensation for a crosswind condition. A crosswind was a factor in the accident.Dec 25, 1994 · N7137T · Substantial damageNTSB MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.Dec 24, 1994 · N2829P · Substantial damageNTSB LAX95LA060Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Searchlight, NVthe pilot's intentional continued flight into instrument meteorological conditions in mountainous terrain.Dec 24, 1994 · N3836T · DestroyedNTSB FTW95LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · La Porte, TXLoss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.Dec 24, 1994 · N2820M · Substantial damageNTSB MIA95LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · La Belle, FLPartial loss of engine power due to total failure of the no. 3 cylinder exhaust valve for undetermined reasons. Also, unsuitable terrain encountered during the forced landing.Dec 23, 1994 · N41774 · Substantial damageNTSB FTW95LA073Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Erie, COThe pilot's failure to maintain airspeed resulting in the inadvertent stall.Dec 23, 1994 · N8389Q · Substantial damageNTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.Dec 23, 1994 · N3221J · Substantial damageNTSB LAX95LA059Accident · No injuriesLimited investigationFinal reportCessna 185A · Long Beach, CAthe pilot's failure to maintain directional control of the aircraft both during the landing and the attempted rejected landing maneuver.Dec 22, 1994 · N101LL · Substantial damageNTSB FTW95LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oklahoma City, OKThe loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.Dec 22, 1994 · N2874R · Substantial damageNTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.Dec 22, 1994 · N7JD · Substantial damageNTSB CHI95FA061Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Rochester, MNFailure of the pilot to maintain control of the airplane, while climbing in instrument meteorological conditions (IMC) after takeoff. Factors related to the accident were: fog, low ceiling, the pilot's lack of recent instrument experience, and the excessive…Dec 22, 1994 · N133MA · DestroyedNTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.Dec 22, 1994 · N1620Y · DestroyedNTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.Dec 21, 1994 · N4607Q · Substantial damageNTSB NYC95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wheeling, WVThe student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.Dec 21, 1994 · N7175S · DestroyedNTSB MIA95WA047Accident · No injuriesForeign investigationNorth American NA-265-40 · Buenos Aires, ArgentinaDec 21, 1994 · N747E · Substantial damageNTSB MIA95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLIn flight planning decision delay by the pilot-in-command in that he failed to divert to an alternate airport before loss of engine power due to fuel exhaustion.Dec 21, 1994 · N82895 · Substantial damageNTSB LAX95LA058Accident · Minor injuriesLimited investigationFinal reportRender LONG-EZ · Kailua-Kona, HIa delamination of the wooden propeller.Dec 21, 1994 · N3250K · DestroyedNTSB LAX95LA057Accident · No injuriesLimited investigationFinal reportCessna 150F · Carlsbad, CAthe pilot's misjudged landing flare which resulted in a stall and a subsequent impact with the runway.Dec 21, 1994 · N6660F · Substantial damageNTSB FTW95FA071Accident · 3 fatalField investigationFinal reportCessna 182G · Muskogee, OKFailure of the pilot to maintain control of the airplane due to spatial disorientation after inadvertently flying into adverse weather. Factors related to the accident were: darkness, the low ceiling, the pilot's inadequate evaluation of the weather, and his…Dec 21, 1994 · N3229S · DestroyedNTSB DCA95RA009Accident · 5 fatalForeign investigationBoeing B737-2D6C · Coventry, AlgeriaDec 21, 1994 · 7TVEE · DestroyedNTSB CHI95LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Allegan, MIthe student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.Dec 21, 1994 · N7656X · Substantial damageNTSB NYC95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gr. Barrington, MAThe pilot landed with excessive airspeed which resulted in a long landing, runway overrun, and collision with trees.Dec 20, 1994 · N4497X · Substantial damageNTSB MIA95WA045Accident · No injuriesForeign investigationMooney M20J · Spanish Cay, BahamasDec 20, 1994 · N201TB · Substantial damageNTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.Dec 20, 1994 · N163BH · Substantial damageNTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.Dec 20, 1994 · N1217B · 2 aircraft · Substantial damageNTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.Dec 19, 1994 · N175MC · Destroyed