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 LAX90LA267Accident · No injuriesLimited investigationFinal reportCessna 150J · Jamul, CAThe pilot's delay in applying carburetor heat.Jul 25, 1990 · N446VK · Substantial damageNTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.Jul 25, 1990 · N2292W · Substantial damageNTSB LAX90DVG17Accident · Minor injuriesFinal reportCloutier Scorpion 133 · Oroville, CAThe pilot's loss of directional control.Jul 25, 1990 · N4639E · Substantial damageNTSB FTW90LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Lytle, TXThe pilot's failure to adequately manage the onboard fuel supply.Jul 25, 1990 · N5278H · DestroyedNTSB FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.Jul 25, 1990 · N7854 · DestroyedNTSB CHI90FA196Accident · No injuriesField investigationFinal reportCessna 172 · Canton, MIThe pilot's inadequate takeoff procedure, premature liftoff and delayed reaction to abort the takeoff.Jul 25, 1990 · N4330Q · Substantial damageNTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.Jul 25, 1990 · N2508D · DestroyedNTSB ANC90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big River, AKThe improper use of brakes by the pilot during the landing roll.Jul 25, 1990 · N75PC · Substantial damageNTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.Jul 24, 1990 · N4184Z · Substantial damageNTSB SEA90LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Redmond, ORThe student pilot's failure to properly recover from a bounced landing.Jul 24, 1990 · N8756G · Substantial damageNTSB MIA90LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · Sarasota, FLImproper control input after the loss of tail rotor effectiveness.Jul 24, 1990 · N2164Z · Substantial damageNTSB LAX90FA265Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Apple Valley, CAImproper preflight planning/decision by the pilot. Factors related to the accident were: failue of the pilot to configure the aircraft's flaps for a soft field takeoff, his improper use of stabilator trim, high density altitude, soft runway, and trees near…Jul 24, 1990 · N41455 · DestroyedNTSB CHI90LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · East Tawas, MIThe private pilot's failure to maintain adequate control of the aircraft after touchdown.Jul 24, 1990 · N6VD · Substantial damageNTSB NYC90FA169Accident · Serious injuriesField investigationFinal reportDavid B. Robertson VARI-EZE · Cincinnati, OHA power loss due to improper installation of a fuel line fitting and inadequate maintenance and inspection.Jul 23, 1990 · N45DR · DestroyedNTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.Jul 23, 1990 · N7202P · Substantial damageNTSB DEN90DTE04Accident · 2 fatalFinal reportOlsen Pursuit · Fowler, COFailure of the pilot to maintain adequate airspeed on final approach to land, which resulted in an inadvertent stall. A factor relate to the accident was: the pilot's physical impairment from carbon monoxide.Jul 23, 1990 · N23GG · DestroyedNTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.Jul 23, 1990 · N93905 · 2 aircraft · Minor damageNTSB CHI90LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Twining, MIThe pilot's inability to maintain adequate control of the aircraft as it decellerated on the runway after touchdown.Jul 23, 1990 · N4356T · Substantial damageNTSB CHI90FA190Accident · 3 fatalField investigationFinal reportPiper PA-28 · Plymouth, MIInadequate visual lookout by the pilot of the PA-60. A factor related to the accident was that neither of the flight crews had obatained atc/radar assistance.Jul 23, 1990 · N55354 · 2 aircraft · DestroyedNTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.Jul 23, 1990 · N89BD · Substantial damageNTSB ATL90LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Sanford, NCThe failure of the no.1 piston, for undetermined reasons, which resulted in a complete loss of engine power. A factor to the accident was, the forced landing in a soft field.Jul 23, 1990 · N58469 · Substantial damageNTSB NYC90LA170Accident · No injuriesLimited investigationFinal reportCessna 340A · Prospect, PAAn on ground collision with terrain after the right main landing gear side brace failed due to shear from the soft, wet, rough runway, allowing the right main landing gear to collapse.Jul 22, 1990 · N555KB · Substantial damageNTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.Jul 22, 1990 · N1994V · No damageNTSB FTW90LA144Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Terrell, TXWrong runway selected by second pilot. Factors were: tailwind and inadequate supervision by pilot-cfi.Jul 22, 1990 · N3850A · Substantial damageNTSB FTW90DRD13Accident · 1 fatalFinal reportde Havilland DH-82A · Youngsville, LAThe pilot's failure to touch down at the proper point on the landing surface. A contributing factor was the late initiation of the aborted landing.Jul 22, 1990 · N5984 · DestroyedNTSB ATL90FA146Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Kinston, NCFailure of the fuel pump control shaft because of improper machining by the repair facility during maintenance modification of the pump and improper procedures during overhaul of the nose landing gear.Jul 22, 1990 · N210US · Substantial damageNTSB SEA90LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Missoula, MTPilot's failure to maintain directional control during the landing roll.Jul 21, 1990 · N2007U · Substantial damageNTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.Jul 21, 1990 · N4153Z · Substantial damageNTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.Jul 21, 1990 · N2724H · Substantial damageNTSB MIA90LA157Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Plant City, FLEngine failure for undetermined reasons resulting in the forced landing.Jul 21, 1990 · N4429N · Substantial damageNTSB MIA90LA156Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jensen Beach, FLFuel exhaustion due to improper planning by the pilot.Jul 21, 1990 · N8761S · DestroyedNTSB LAX90LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Clarksburg, CAThe failure of the airplane's muffler during initial climb.Jul 21, 1990 · N1570J · Substantial damageNTSB LAX90DVG13Accident · Serious injuriesFinal reportCharles T. Brietigam RV-4 · San Andreas, CAThe failure of four propeller retention bolts which required the engine to be shut down. A factor in the accident was the pilot's misjudgement of the forced landing approach.Jul 21, 1990 · N87CT · DestroyedNTSB FTW90LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Berwick, LAPilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.Jul 21, 1990 · N3598F · Substantial damageNTSB FTW90DRA07Accident · 1 fatalFinal reportBensen B-8M · Hearne, TXThe pilot's loss of control in flight due to excessive control inputs and his abrupt attempts to recover control of the aircraft prior to impact.Jul 21, 1990 · N130MP · DestroyedNTSB CHI90DEE08Accident · No injuriesFinal reportRonald D. Cothern Quickie · Plainfield, ILSeparation of an ignition lead, resulting in loss of engine power. A factor in the accident was the pilot's inadequate preflight inspection.Jul 21, 1990 · N701RC · Substantial damageNTSB ANC90LA122Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Louise, AKThe pilot's failure to maintain directional control during landing. A contributing factor was a crosswind.Jul 21, 1990 · N7866U · Substantial damageNTSB LAX90LA262Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Long Beach, CAThe pilot's improper planning/decision, which resulted in fuel exhaustion.Jul 20, 1990 · N4950P · Substantial damageNTSB LAX90LA261Accident · No injuriesLimited investigationFinal reportCessna 180B · Red Bluff, CAAn improper landing flare and improper recovery from the bounced landing.Jul 20, 1990 · N20KB · Substantial damageNTSB LAX90FA260Accident · 1 fatalField investigationFinal reportBeech B36TC · Santee, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions, and his loss of control due to spatial disorientation. Factors contributing to the accident were: the pilot's failure to obtain a weather briefing, the existing weather…Jul 20, 1990 · N72035 · DestroyedNTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.Jul 20, 1990 · N78EJ · Substantial damageNTSB FTW90DRA06Accident · Minor injuriesFinal reportHuffaher Benson · Hearne, TXThe pilot's failure to adequately compensate for the tail wind condiitons during a low pass which exceeded the performance capability of the aircraft. A factor was the tail wind conditions.Jul 20, 1990 · N70136 · Substantial damageNTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.Jul 20, 1990 · N16088 · Substantial damageNTSB SEA90LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Island Park, IDImproper planning/decision by the pilot. The high density altitude and the pilot's overconfidence in the aircraft's ability were related factors.Jul 19, 1990 · N5011T · Substantial damageNTSB NYC90LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, NYThe failure of the pilot to maintain directional control during a rejected landing. Factors related to the accident were: improper use of the flight controls by the pilot, a variable wind, and lack of expereince in type of airplane.Jul 19, 1990 · N15595 · Substantial damageNTSB FTW90LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Worth, TXPilot's failure to maintain directional control. Contributing to the accident was the pilot's diverted attention.Jul 19, 1990 · N704JU · Substantial damageNTSB CHI90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Graceton, MNVso airspeed not maintained and stall encountered by the pilot in command/cfi.Jul 19, 1990 · N7895G · Substantial damageNTSB CHI90LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNThe pilot's failure to perform fuel consumption calculations which resulted in fuel exhaustion and subsequent loss of engine power. Factor was rough/uneven terrain.Jul 19, 1990 · N2134Z · Substantial damageNTSB CHI90LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe instructor's inability to control the airplane during its landing roll.Jul 19, 1990 · N5538P · DestroyedNTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.Jul 19, 1990 · N206AT · Minor damage