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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB ANC92LA165Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Talkeetna, AKThe student pilot's failure to maintain directional control on landing roll.NTSB 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.NTSB 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.NTSB LAX92LA381Accident · 1 fatalLimited investigationFinal reportWarren-Thomas BD-5J · Chico, CAThe pilot misjudged the aerobatic maneuver recovery altitude.NTSB 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.NTSB CHI92FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 150H · Manistee, MIUndeterminedNTSB 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.NTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.NTSB 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.…NTSB 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.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB BFO92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Brandenburg, KYThe pilot's in-flight planning/decision which resulted in fuel exhaustion.NTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.NTSB 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.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.NTSB ANC92LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Bethel, AKThe carburetor icing conditions and the delay by the pilot in command/cfi in using carburetor heat.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.NTSB 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.NTSB 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.NTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB CHI92DCD10Accident · Minor injuriesFinal reportCurt Hoffstad Pitts S1-S · Council Bluffs, IAThe failure of the pilot to maintain aircraft control while maneuvering during aerobatic flight.NTSB 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.NTSB 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.NTSB 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.NTSB 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.