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 FTW93LA152Accident · No injuriesLimited investigationFinal reportElliott B-80 · Amarillo, TXThe pilot's failure to compensate for wind conditions. Factors were the loss of engine power and the tailwindMay 12, 1993 · N42845 · DestroyedNTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.May 12, 1993 · N3162A · Substantial damageNTSB CHI93DER01Accident · 1 fatalFinal reportPitts S1 · Madison, MNThe pilot's failure to maintain adequate terrain clearance during aerobatic maneuvers.May 12, 1993 · N17FS · DestroyedNTSB BFO93LA084Accident · No injuriesLimited investigationFinal reportCessna A150M · Tarentum, PAFailure of the pilot to maintain directional control and proper runway alignment. The adverse weather condition and proximity of the parked aircraft were related factors.May 12, 1993 · N9891J · Substantial damageNTSB BFO93LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Shirley, NYFailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve, and his failure to maintain sufficient clearance and or altitude from the trees. The proximity of trees was a related factor.May 12, 1993 · N8612V · DestroyedNTSB BFO93FA082Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Lyburn, WVFailure of the pilot to attain sufficient altitude to remain clear of rising terrain and objects. Factors related to the accident were darkness and rising terrain.May 12, 1993 · N45087 · DestroyedNTSB SEA93LA104Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Seaside, ORThe pilot in command's delaying the go around. Factors contributing to the accident were tailwinds and the pilot in command's misjudgement of wind information.May 11, 1993 · N435BW · Substantial damageNTSB MIA93LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Ochopee, FLThe pilot's poor judgement in attempting the takeoff from the parking ramp when a 12,000-FT runway was available.May 11, 1993 · N9985V · Substantial damageNTSB LAX93LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ynez, CAThe pilot's poor procedures and failure to fly to an alternate airport. Factors relating to this accident were: the pilot's lack of total experience, encounter with unfavorable winds, and the dark night.May 11, 1993 · N76284 · Substantial damageNTSB LAX93LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Elko, NVThe pilot's failure in not determining the surface winds prior to landing which resulted in a landing in conditions beyond the demonstrated capability of the airplane.May 11, 1993 · N714ZL · Substantial damageNTSB FTW93LA151Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ville Platte, LAThe pilot's failure to maintain ground clearanceMay 11, 1993 · N91AY · Substantial damageNTSB DEN93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe student's failure to maintain proper touchdown alignment, and the instructor pilot's inadequate supervision.May 11, 1993 · N7198Y · DestroyedNTSB CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.May 11, 1993 · N5589N · Substantial damageNTSB ANC93LA062Accident · No injuriesLimited investigationFinal reportCessna 182 · Blair Lakes, AKThe pilots selection of unsuitable terrain on which to land. A factor was the soft, wet, rough area on the strip.May 11, 1993 · N6374B · Substantial damageNTSB CHI93IA167Incident · No injuriesIncident investigationFinal reportCessna 550 · West Chicago, ILInadequate control tower service by the local air traffic controller by providing conflicting clearances to the pilots of two aircraft.May 10, 1993 · N41SM · No damageNTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.May 10, 1993 · N9222G · DestroyedNTSB BFO93LA079Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittstown, NJThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve. The gusty wind and proximity of the parked airplane were related factors.May 10, 1993 · N54833 · Substantial damageNTSB ATL93LA091Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilmington, NCThe ground personnel's failure to ensure that the airplane was clear of obstructions which resulted in the right wing colliding with a utility pole. A factor was the pilot's inadequate visual lookoutMay 10, 1993 · N4856D · Substantial damageNTSB SEA93LA106Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Fort Benton, MTInadequate inflight planning/decision. Factors to the accident were: turbulence, downdrafts, poor weather evaluation and altitude not maintained.May 9, 1993 · N56542 · Substantial damageNTSB LAX93LA206Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Redlands, CAThe pilot's delayed landing abort during a downwind landing. Factors which contributed to the accident were: an incorrect advisory by the UNICOM operator, inadequate wind direction determination by the pilot which resulted in the wrong runway selected, and…May 9, 1993 · N5810L · Substantial damageNTSB LAX93LA205Accident · No injuriesLimited investigationFinal reportCessna 195B · Placerville, CAThe unreliability of the normal brake system and the leaking master cylinderMay 9, 1993 · N2171C · Substantial damageNTSB FTW93FA150Accident · 2 fatalField investigationFinal reportCessna 150M · Liberty Hill, TXThe inadvertent stall with insufficient altitude to recover before terrain contact.May 9, 1993 · N63574 · DestroyedNTSB CHI93LA169Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Garden City, KSThe pilot-in-command's not maintaining proper altitude.May 9, 1993 · N731DD · Substantial damageNTSB CHI93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Houghton Lake, MIThe pilot operating the airplane with a known deficiency.May 9, 1993 · N7303M · DestroyedNTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.May 9, 1993 · N2894V · Substantial damageNTSB BFO93LA078Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Frederick, MDInadequate preflight by the pilot and fuel contamination, which resulted in loss of engine power.May 9, 1993 · N28681 · Substantial damageNTSB BFO93LA076Accident · Minor injuriesLimited investigationFinal reportHockenbury Bowers FLY Baby · Peapack, NJThe failure of the throttle valve actuating arm which resulted in partial opening of the throttle valve. A factor related to the accident was the unsuitable terrain available for landing.May 9, 1993 · N80PH · Substantial damageNTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.May 9, 1993 · N82836 · Substantial damageNTSB ATL93LA090Accident · No injuriesLimited investigationFinal reportRapp VAN'S RV-4 · Greenwood, SCThe loss of engine power which resulted from the formation of carburetor ice. The lack of a carburetor heat source and the carburetor icing conditions were factorsMay 9, 1993 · N743DR · DestroyedNTSB SEA93LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Kapowsin, WAAn undetermined loss of engine power.May 8, 1993 · N9534H · Substantial damageNTSB MIA93LA118Accident · No injuriesLimited investigationFinal reportCessna 172P · Mims, FLTotal loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the pilot to lean the fuel/air mixture during cruise flight which increased the fuel consumption for the flight.May 8, 1993 · N63012 · Substantial damageNTSB LAX93LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Reedley, CAA failure of the pilot to maintain proper runway alignment and improper remedial action during the balked landing. A factor in the accident was a lack of total aeronautical experience.May 8, 1993 · N4149J · Substantial damageNTSB LAX93LA208Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Corona, CAThe failure of the pilot to accomplish the published emergency procedure by not immediately lowering the collective to regain main rotor RPM. A factor in the accident was the pilot's selection of a cruise altitude insufficient to allow for contingency…May 8, 1993 · N4071G · DestroyedNTSB BFO93LA077Accident · Serious injuriesLimited investigationFinal reportForest Ripley Z MAX · Delaware, OHThe loss of engine power for undetermined reasons.May 8, 1993 · N72GR · DestroyedNTSB BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.May 8, 1993 · N1329E · Substantial damageNTSB BFO93LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Towanda, PAThe failure of the aileron control cable which resulted in loss of control in flight.May 8, 1993 · N3914F · DestroyedNTSB BFO93LA072Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Simsbury, CTLack of braking action from the right brake. The pilot's failure to attain the proper touchdown point was a related factor.May 8, 1993 · N47448 · Substantial damageNTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceMay 8, 1993 · N16897 · Substantial damageNTSB ANC93FA061Accident · Minor injuriesField investigationFinal reportBell 214B1 · Thorne Bay, AKForeign object damage to the compressor assembly, probably due to loose nuts from the compressor case after improper maintenance (installation) by maintenance personnel.May 8, 1993 · N314CR · Substantial damageNTSB LAX93LA207Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Corona, CAthe pilot improper maintenance modification and total failure of the magneto.May 7, 1993 · N250P · DestroyedNTSB CHI93LA327Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace ATP · Green Bay, WIthe passenger's loss of footing (miscellaneous).May 7, 1993 · N852AW · No damageNTSB BFO93LA071Accident · Minor injuriesLimited investigationFinal reportAmerican General AG5B · Princeton, NJThe pilot's misjudgement of distance and speed during the landing, and his failure to initiate a go around, while there was still sufficient speed and runway remaining. His failure to attain the proper touchdown point for the landing was a related factor.May 7, 1993 · N1192P · Substantial damageNTSB BFO93IA070Incident · Minor injuriesIncident investigationFinal reportFokker F28-MK-0100 · Pittsburgh, PAThe improper installation of the spacers by the mechanic and the unclear information supplied from the manufacturer and operator regarding the installation of the spacers.May 7, 1993 · N867US · Minor damageNTSB LAX93LA211Accident · No injuriesLimited investigationFinal reportCessna 140 · Ramona, CAA jammed control yoke.May 6, 1993 · N76194 · Substantial damageNTSB LAX93LA204Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Pixley, CAthe pilot's failure to maintain flying speed during the turn. The inadvertent stall was a factor in this accident.May 6, 1993 · N4749Y · Substantial damageNTSB DEN93FA054Accident · 1 fatalField investigationFinal reportWitts & Church Worloch · Lucerne, COLoss of control in flight. A factor was: the pilot's lack of experience in the airplane.May 6, 1993 · N3201K · DestroyedNTSB CHI93DEX01Accident · No injuriesFinal reportZeigler Moni · Seymour, INan inadvertent stall. Factors relating to the accident are the major alteration of the airframe, and failure of the pilot-in- command to obtain new performance data.May 6, 1993 · N10GZ · Substantial damageNTSB ATL93LA088Accident · Serious injuriesLimited investigationFinal reportExtra 300 · Ridge Springs, SCThe pilot's failure to determine the landing distance required for a landing on a wet sod runway, which resulted in the overrun of the landing area and the collision with a treeMay 6, 1993 · N694DM · Substantial damageNTSB ANC93FA060Accident · No injuriesField investigationFinal reportCessna 207 · Holy Cross, AKThe failure of the pilot in command to maintain the proper altitude. The trees were a factor in the accident.May 6, 1993 · N70364 · DestroyedNTSB MIA93IA120Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Daytona Beach, FLFatigue failure of the drag link assembly bolt.May 5, 1993 · N21427 · Minor damage