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 ANC92LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Seldovia, AKThe failure of the pilot to perform a go around when a tail wind was encountered prior to touch down. Factors related to the accident were: the tailwind and the downdraft.Sep 13, 1992 · N734VL · Substantial damageNTSB ANC92LA165Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Talkeetna, AKThe student pilot's failure to maintain directional control on landing roll.Sep 13, 1992 · N11098 · Substantial damageNTSB LAX92LA383Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe pilot/passenger's failure to maintain adequate rotor RPM and the pilot-in-command's inadequate supervision of the flight.Sep 12, 1992 · N58164 · Substantial damageNTSB LAX92LA382Accident · No injuriesLimited investigationFinal reportCessna 172N · Fillmore, CAThe first pilot's poor inflight decision to fly into a box canyon. Contributing to this accident was the box canyon and the downdraft.Sep 12, 1992 · N2212W · Substantial damageNTSB LAX92LA381Accident · 1 fatalLimited investigationFinal reportWarren-Thomas BD-5J · Chico, CAThe pilot misjudged the aerobatic maneuver recovery altitude.Sep 12, 1992 · N45DH · DestroyedNTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.Sep 12, 1992 · N5361K · Substantial damageNTSB CHI92FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 150H · Manistee, MIUndeterminedSep 12, 1992 · N6759S · DestroyedNTSB SEA92LA201Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAInadequate remedial action of the pilot in command (CFI). Factors include airspeed not being maintained by the student pilot, and rough/uneven terrain.Sep 11, 1992 · N1482T · Substantial damageNTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.Sep 11, 1992 · N6107U · Substantial damageNTSB DCA92MA049Accident · 6 fatalClass 1 · MajorFinal reportMitsubishi MU-2B-60 · Greenwood, INThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the pilots of the MU-2 and the PA-32 from recognizing a collision hazard and taking actions to avoid the midair collision.…Sep 11, 1992 · N74FB · 2 aircraft · DestroyedNTSB CHI92LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Marlette, MIThe pilot-in-command's (CFI) inadequate supervision of the dual student pilot and the dual student's inadvertent application of the brakes.Sep 11, 1992 · N50905 · Substantial damageNTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.Sep 11, 1992 · N6555Q · Substantial damageNTSB BFO92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Brandenburg, KYThe pilot's in-flight planning/decision which resulted in fuel exhaustion.Sep 11, 1992 · N83628 · Substantial damageNTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.Sep 11, 1992 · N6105G · Substantial damageNTSB BFO92FA135Accident · 2 fatalField investigationFinal reportBeech G35 · Hillsville, VALoss of engine power for an undetermined reason and failure of the pilot to maintain airspeed, which resulted in a stall/spin.Sep 11, 1992 · N4526D · DestroyedNTSB ANC92FA164Accident · 3 fatalField investigationFinal reportMcdonnell Douglas 369D · Eagle, AKAn inflight fatigue failure and separation of a main rotor blade, inadequate operator maintenance and inspection, and material defect.Sep 11, 1992 · N1096X · DestroyedNTSB ANC92FA162Accident · 2 fatalField investigationFinal reportChampion 7EC · Seward, AKThe pilot-in-command's failure to maintain an adequate altitude in mountainous terrain, in moderate-to-severe turbulent conditions, which resulted in a loss of control. In addition, the pilot was physically impaired due to alcohol. Factors contributing to the…Sep 11, 1992 · N4362C · DestroyedNTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.Sep 10, 1992 · N4333S · Substantial damageNTSB LAX92LA380Accident · No injuriesLimited investigationFinal reportCessna 172N · Stanfield, AZThe cfi's poor in-flight decision to demonstrate the simulated engine out emergency landing at too low an altitude and misjudging the altitude during the circling maneuver.Sep 10, 1992 · N734UT · Substantial damageNTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.Sep 10, 1992 · N3683Y · Substantial damageNTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.Sep 10, 1992 · N55410 · Substantial damageNTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.Sep 10, 1992 · N8823S · Substantial damageNTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.Sep 10, 1992 · N92427 · DestroyedNTSB ANC92LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Bethel, AKThe carburetor icing conditions and the delay by the pilot in command/cfi in using carburetor heat.Sep 10, 1992 · N7763F · Substantial damageNTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.Sep 10, 1992 · N3384Z · Substantial damageNTSB SEA92LA202Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Cave Junction, ORThe pilot's poor visual lookout. Factors include a static wire in the area of flight.Sep 9, 1992 · UNREG · Substantial damageNTSB LAX92LA379Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Tranquillity, CAThe pilot's improper inflight planning; his failure to attain the proper descent rate; and the excessive descent. Contributing to this accident was the landing gear collapse due to overload.Sep 9, 1992 · N5674X · Substantial damageNTSB CHI92LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotland, INThe pilot's delay in aborting a takeoff attempt after failing to attain flying speed during a takeoff ground run.Sep 9, 1992 · N67836 · Substantial damageNTSB CHI92LA269Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gary, INThe pilot's failure to land at the proper touchdown point on the runway and landing with excessive airspeed.Sep 9, 1992 · N33662 · Substantial damageNTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Sep 9, 1992 · N24600 · Substantial damageNTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, self-induced pressure…Sep 9, 1992 · N5533N · DestroyedNTSB ATL92LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Boone, NCThe pilot's failure to abort the take off, and his abrupt pull up with insufficient airspeed to continue flight. Factors were the inadequate airspeed and the inadvertent stall.Sep 9, 1992 · N19797 · Substantial damageNTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.Sep 9, 1992 · N1999P · Substantial damageNTSB ANC92FA159Accident · Serious injuriesField investigationFinal reportHughes 369D · Nunavaugaluk Lk, AKThe separation of the tail rotor abrasion strip and the subsequent total loss of the tail rotor. Factors contributing to the accident were: insufficient manufacturer's maintenance design changes, inadequate aircraft equipment design by the manufacturer and…Sep 9, 1992 · N8697F · Substantial damageNTSB LAX92LA377Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, CAThe unknown pilots improper use of the throttles which resulted in the overboosting of the engine. Contributing to the accident was the maintenance personnel improper maintenance in adjusting the turbocharger wastegate and the oil leaking from the engine…Sep 8, 1992 · N20926 · DestroyedNTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.Sep 8, 1992 · N3743P · Substantial damageNTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.Sep 8, 1992 · N5029Z · Substantial damageNTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.Sep 8, 1992 · N717BB · DestroyedNTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.Sep 8, 1992 · N2509D · DestroyedNTSB ANC92LA175Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Ptarmigan Pass, AKThe partial failure of the normal brake system, the misjudging of the proper touchdown point and the attempted go around. Factor was the rough and uneven landing area.Sep 8, 1992 · N1009H · Substantial damageNTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.Sep 7, 1992 · N4316 · 2 aircraft · DestroyedNTSB MIA92LA177Accident · No injuriesLimited investigationFinal reportCessna A150K · Palatka, FLThe pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground.Sep 7, 1992 · N8367M · Substantial damageNTSB MIA92LA176Accident · No injuriesLimited investigationFinal reportCessna 172I · Navarre, FLFailure of the pilot-in-command to maintain directional control after touchdown during the forced landing following partial loss of engine power during cruise flight. Contributing to the accident was the divertion of attention of the pilot in command to the…Sep 7, 1992 · N35302 · Substantial damageNTSB MIA92LA175Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hollywood, FLThe pilot-in-command's failure to refuel the airplane which resulted in a total loss of engine power in flight due to fuel exhaustion, subsequent forced landing, and on ground collision with a tree on landing roll out.Sep 7, 1992 · N6664S · Substantial damageNTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…Sep 7, 1992 · N3657G · DestroyedNTSB CHI92DCD10Accident · Minor injuriesFinal reportCurt Hoffstad Pitts S1-S · Council Bluffs, IAThe failure of the pilot to maintain aircraft control while maneuvering during aerobatic flight.Sep 7, 1992 · N90LB · Substantial damageNTSB BFO92LA130Accident · No injuriesLimited investigationFinal reportSchweizer 1-26D · Blairstown, NJThe pilot's failure to use spoilers which resulted in a landing overrun. Contributing was the pilot's lack of familiarity with the aircraft.Sep 7, 1992 · N7734S · Substantial damageNTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.Sep 7, 1992 · N400RD · Substantial damageNTSB BFO92LA128Accident · No injuriesLimited investigationFinal reportCessna 172 · Groveport, OHThe pilot's inadequate preflight planning by selecting unsuitable soft terrain which resulted in a nose over during an aborted takeoff.Sep 7, 1992 · N6044A · Substantial damageNTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.Sep 6, 1992 · N78599 · Substantial damage