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 FTW92LA181Accident · No injuriesLimited investigationFinal reportCessna 120 · Reserve, LAThe loss of engine power due to the valve failure. A factor was the lack of suitable terrain for the forced landing.Jul 19, 1992 · N89970 · Substantial damageNTSB BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Jul 19, 1992 · N78483 · Substantial damageNTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.Jul 19, 1992 · N75255 · Substantial damageNTSB LAX92LA304Accident · No injuriesLimited investigationFinal reportCessna 182Q · Montague, CAThe pilot failure to maintain directional control.Jul 18, 1992 · N97799 · Substantial damageNTSB LAX92LA303Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Simi Valley, CAThe company's maintenace personnel improper adjustment of the aircraft's idle RPM and the failure of the instructor pilot to maintain adequate rotor RPM after the engine failed. The instructor pilot's lack of total experience in type of operation is a factor…Jul 18, 1992 · N280CA · Substantial damageNTSB LAX92LA302Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Ukiah, CAThe pilot's failure to maintain directional control of the aircraft during the aborted landing and initial climb-out. The pilot's improper landing flare, the inadvertent porpoise, and his improper recovery from a bounced landing were factors in the accident.Jul 18, 1992 · N2499F · Substantial damageNTSB LAX92IA307Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAA failure of ground personnel to ensure proper clearance between a taxiing airplane and an adjacent parked airplane. Contributing to the accident was a failure of ground personnel to properly position a parked airplane to ensure that it did not encroach into…Jul 18, 1992 · N719DA · 2 aircraft · No damageNTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.Jul 18, 1992 · N1342 · Substantial damageNTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.Jul 18, 1992 · N4500E · DestroyedNTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.Jul 18, 1992 · N4766Y · DestroyedNTSB LAX92LA301Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Fresno, CAThe cfi's poor in-flight decision to proceed over the trees instead of the previously performed right circling turns and both pilots inadequate visual look-out. Contributing to this accident were the trees that partially obstructed the view of the power line…Jul 17, 1992 · N83556 · DestroyedNTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.Jul 17, 1992 · N6959C · DestroyedNTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.Jul 17, 1992 · N3488B · Substantial damageNTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.Jul 17, 1992 · N160MJ · Substantial damageNTSB SEA92LA156Accident · Minor injuriesLimited investigationFinal reportThomsen, Horst Rotorway "EXEC" · Quilcene, WAA misjudged descent rate, and delayed corrective action. Factors include a lack of experience in this type of aircraft, and a building near the landing area.Jul 16, 1992 · UNREG · Substantial damageNTSB LAX92LA300Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Five Points, CAThe failure of airport personnel to perform the necessary runway maintenance. Contributing to this accident was the dark night and high vegetation.Jul 16, 1992 · N3105V · Substantial damageNTSB LAX92LA299Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Shafter, CAThe pic's poor preflight planning and the pic's and flight instructor/passenger's failure to use the emergency checklist. The loss of engine power due to fuel starvation was a factor in the accident.Jul 16, 1992 · N327PL · Substantial damageNTSB LAX92LA298Accident · No injuriesLimited investigationFinal reportCessna 150L · Pittsburg, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. The rough/uneven terrain is a factor in this accident.Jul 16, 1992 · N7521G · Substantial damageNTSB FTW92LA186Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gould, ARThe aircraft crosswind landing capability was exceeded. A factor was the the gusting crosswind.Jul 16, 1992 · N949LR · Substantial damageNTSB BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.Jul 16, 1992 · N8432R · Substantial damageNTSB ANC92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's improper preflight planning/decision, and his delayed aborted takeoff. Contributing was the pilot's failure to use the airplane performance data.Jul 16, 1992 · N7096K · Substantial damageNTSB FTW92IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Oklahoma City, OKHydraulic fluid exhaustion due to the chafed 'a' system hydraulic line and the improper installation by unknown maintenance personnel of the 'b' system line.Jul 15, 1992 · N12235 · No damageNTSB FTW92DPG09Accident · Serious injuriesFinal reportAir Tractor AT-301A · Fisher, ARA loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed above a stall.Jul 15, 1992 · N3652B · Substantial damageNTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.Jul 15, 1992 · N1324E · Substantial damageNTSB BFO92LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Southwick, MAImproper adjustment of the stabilizer control system by maintenance personnel.Jul 15, 1992 · N3109G · Substantial damageNTSB ATL92FA139Accident · 2 fatalField investigationFinal reportBeech 58P · Greenville, GAContinued flight by the pilot into an area of known adverse weather, and his failure to maintain control of the aircraft, which resulted in exceeding the design stress limits of the plane and overload failure of the stabilizers and wings. The adverse weather…Jul 15, 1992 · N3810L · DestroyedNTSB ATL92FA138Accident · 2 fatalField investigationFinal reportKory G. Cornum SH-3R · Auburn, ALThe failure of the pilot-in-command to maintain adequate airspeed after initiating a maneuver from low altitude. A factor was the lack of sufficient altitude.Jul 15, 1992 · N383KR · DestroyedNTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.Jul 14, 1992 · N68857 · Substantial damageNTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.Jul 14, 1992 · N62404 · Substantial damageNTSB LAX92T#A11Accident · No injuriesClass 3Final reportMaule MX7-420 · Reno, NVJul 14, 1992 · N420PT · Substantial damageNTSB LAX92LA297Accident · No injuriesLimited investigationFinal reportKrug Lincoln Sportplane · Corona, CAThe pilot/builder inadequate propeller component resulting in an inadequate climb performance. Contributing to this accident was the airplane's inability to climb.Jul 14, 1992 · N377JK · Substantial damageNTSB MIA92LA149Accident · No injuriesLimited investigationFinal reportMooney M20C · Pass-A-Grille, FLTotal loss of engine power due to fuel starvation.Jul 13, 1992 · N9379A · Substantial damageNTSB FTW92LA179Accident · No injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXThe pilot's failure to maintain directional control. Factors were the inadvertent porpoise of the airplane and the pilot's lack of total experience in the type airplane.Jul 13, 1992 · N3425T · Substantial damageNTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.Jul 13, 1992 · N66315 · Substantial damageNTSB BFO92LA097Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bedford, PAThe pilot failed to maintain adequate airspeed which resulted in a stall.Jul 13, 1992 · N61941 · DestroyedNTSB ANC92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot's inadvertent stalling of the airplane and an inadequate altitude in which he could recover. Factor relating to the accident was the water in the fuel.Jul 13, 1992 · N61272 · Substantial damageNTSB ANC92FA106Accident · 1 fatalField investigationFinal reportShort Brothers SC7 · Bethel, AKInadequate security of the cargo which shifted rearward during the takeoff roll. Factors which contributed to the accident were: the over gross weight condition, and the improper alteration of the tie down rings by the overhauling maintenance facility.Jul 13, 1992 · N20086 · DestroyedNTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.Jul 12, 1992 · N382W · Substantial damageNTSB LAX92LA322Accident · No injuriesLimited investigationFinal reportBeech A23A · Chico, CA1) The pilot's inadvertent entry into instrument meteorological conditions, 2) his failure to maintain control of the aircraft due to spatial disorientation, 3) the inadvertent entry into a spiral dive at an excessive airspeed, and, 4) the pilot's improper…Jul 12, 1992 · N7904L · Substantial damageNTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.Jul 12, 1992 · N7955V · Substantial damageNTSB BFO92LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beavertown, PAThe pilot's failure to maintain ground clearance. Contributing to the accident was a downdraft and insufficient altitude.Jul 12, 1992 · N4754Z · DestroyedNTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.Jul 12, 1992 · N31683 · DestroyedNTSB BFO92LA098Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bally, PAThe pilot failed to maintain directional control during takeoff.Jul 12, 1992 · N57472 · DestroyedNTSB ANC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Watana Lodge, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's failure to attain the proper touch down point, and the loose object (large rock) on the landing strip.Jul 12, 1992 · N1387C · Substantial damageNTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.Jul 11, 1992 · N8348B · Substantial damageNTSB SEA92LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Delta, UTThe failure of an intake valve and the poorly executed forced landing.Jul 11, 1992 · N9871G · Substantial damageNTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.Jul 11, 1992 · N109YV · No damageNTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.Jul 11, 1992 · N5988E · DestroyedNTSB MIA92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sanford, FLInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid of the power line. The proximity of the power line was a related factor.Jul 11, 1992 · N2135E · Substantial damageNTSB LAX92LA296Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Soledad, CAThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.Jul 11, 1992 · N28410 · Substantial damage