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 NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).Jan 23, 1991 · N4626F · Substantial damageNTSB FTW91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Enid, OKThe mechanical failure of the ignition switch. A factor was the pilot's failure to apply the parking brake or use airplane wheel chocks.Jan 23, 1991 · N82162 · Substantial damageNTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.Jan 23, 1991 · N4718D · Substantial damageNTSB ATL91FA042Accident · 1 fatalField investigationFinal reportCessna 310 · Brunswick, GAThe incapacitation of the pilot.Jan 23, 1991 · N3602D · DestroyedNTSB SEA91LA045Accident · No injuriesLimited investigationFinal reportCessna C-150L · Alderwood Manor, WAThe failure of the pilot in command to attain proper clearance from terrain. A factor relating to this accident was the night light conditions.Jan 22, 1991 · N5437Q · Substantial damageNTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…Jan 22, 1991 · N67315 · Substantial damageNTSB LAX91LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Sacramento, CAThe flight's inadvertant encounter with wake turbulence.Jan 22, 1991 · N96306 · DestroyedNTSB CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.Jan 22, 1991 · N5345D · Substantial damageNTSB LAX91LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-300 · Anaheim, CAMaintenance personnel in that they improperly adjusted the left magneto which resulted in the complete erosion of the electrodes from six of the twelve installed spark plugs. The installation of spark plugs with colder heat ranges than specified by the…Jan 21, 1991 · N1885H · Substantial damageNTSB DEN91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe inadequate supervision of the student by the flight instructor. A factor was: the student's failure to flare the aircraft.Jan 21, 1991 · N6374M · Substantial damageNTSB CHI91LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Erskine, MNThe pilot's failure to maintain directional control during the precautionary landing. A factor was the instructor pilot's inadequate supervision of the flight.Jan 21, 1991 · N95684 · Substantial damageNTSB CHI91IA078Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · St. Paul, MNThe partial failure of the airplane's auxiliary power unit, and the inadequate component produced by the manufacturer.Jan 21, 1991 · N295US · Minor damageNTSB DEN91FA034Accident · 1 fatalField investigationFinal reportCessna 150H · Mancos, COFailure of the student pilot to follow procedures and directives by continuing the flight at night and subsequently encountering adverse weather conditions. Factors related to the accident were: darkness, the student's lack of experience, adverse weather…Jan 20, 1991 · N7248S · Substantial damageNTSB CHI91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIThe pilot's failure to maintain directional control.Jan 20, 1991 · N94647 · Substantial damageNTSB CHI91LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MODirectional control was not maintained by the pilot. Factors related to the accident were: a lack of total experience by the pilot and the presence of a snowbank adjacent to the runway.Jan 20, 1991 · N5363Q · Substantial damageNTSB CHI91LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Cabool, MOFailure of the pilot to maintain proper runway alignment during a go-around. Factors related to the accident were: darkness and the pilot's lack of understanding of the landing gear electrical system.Jan 20, 1991 · N5627P · Substantial damageNTSB BFO91LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Fredericksburg, VAThe pilot's misjudgment of distance (runway remaining) after the aircraft touched down and/or his failure to go-around when there was still sufficient speed to do so.Jan 20, 1991 · N1163D · Substantial damageNTSB ATL91FA040Accident · 4 fatalField investigationFinal reportRockwell 114 · Bessemer, ALFailure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.Jan 20, 1991 · N4827W · DestroyedNTSB SEA91LA044Accident · No injuriesLimited investigationFinal reportSchweizer Hughes 269C · Princeton, ORThe pilot's attempt to hover out of ground effect at a density altitude and gross weight in tailwind weather conditions that exceeded the aircraft performance limits. Factors relating to the accident were the high density altitude and tailwind weather…Jan 19, 1991 · N75070 · Substantial damageNTSB NYC91LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Sherburne, VTThe pilots intentional flight into icing conditions with an airplane not equipped for flight in known icing conditions. This resulted in an uncontrolled descent and contact with trees in instrument meteorological conditions. Factors related to the accident…Jan 19, 1991 · N777CL · DestroyedNTSB MIA91LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Orlando, FLFailure of the pilot to follow proper procedures resulting in a gearup landing.Jan 19, 1991 · N27759 · Substantial damageNTSB LAX91LA077Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bakersfield, CAThat the pilot failed to properly compensate for the wind conditions. Contributing to this accident was the existing crosswind.Jan 19, 1991 · N71745 · Substantial damageNTSB LAX91LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Mokuleia, HIThe cfi's failure to use carburetor heat. A factor was the manufacturer's inadequate procedure.Jan 19, 1991 · N3043D · DestroyedNTSB FTW91FA031Accident · 3 fatalField investigationFinal reportBell B 206B III · So. Pass Blk 70The pilot's loss of control of the aircraft for undetermined reasons shortly after departure. Factors in the accident were the restrictions to visibility that existed at the time.Jan 19, 1991 · N2269V · DestroyedNTSB CHI91DEC01Accident · 1 fatalFinal reportMocock Avid Amphibian · Milford, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall. A factor related to the accident were the gusty wind conditions.Jan 19, 1991 · N126TT · DestroyedNTSB CHI91DCQ03Accident · Serious injuriesFinal reportRans S-11 Pursuit · Hays, KSAn engine failure caused by a seized piston. A factor associated with the accident is the failure of the pilot to maintain a proper descent rate during his forced landing.Jan 19, 1991 · N2164K · Substantial damageNTSB ATL91FA041Accident · 2 fatalField investigationFinal reportBeech K35 · Lafayette, TNPartial loss of engine for an undetermined reason. The adverse weather conditions, darkness, and radio tower were related factors.Jan 19, 1991 · N99RN · DestroyedNTSB DEN91LA036Accident · 1 fatalLimited investigationFinal reportCessna 180K · Patterson, LAThe pilot's failure to identify an unsafe or hazardous condition. Factors were: rough water and high winds.Jan 18, 1991 · N63130 · Minor damageNTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.Jan 18, 1991 · N18583 · Substantial damageNTSB CHI91IA073Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-200 · Chicago, ILCompany procedures and directives not being followed by ground personnel. A factor associated with the accident is complacency by company/operator management.Jan 18, 1991 · N608AW · Minor damageNTSB ATL91FA039Accident · 1 fatalField investigationFinal reportBeech 35 · Arden, NCFor undetermined reasons, the engine lost power.Jan 18, 1991 · N4589V · DestroyedNTSB ANC91LA021Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Two Moon Bay, AKThe pilot-in-command's failure to maintain airspeed above a stall while maneuvering in mountainous terrain.Jan 18, 1991 · N4294K · Substantial damageNTSB NYC91FA060Accident · 2 fatalField investigationFinal reportMooney M20J · Brookline, NHThe failure of the flight instructor (CFI) to attain remedial action after control of the airplane was lost for an unknown reason.Jan 17, 1991 · N804DW · DestroyedNTSB MIA91LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLInadequate maintenance record keeping by the operation, and failure of the CFI to follow procedures and directives.Jan 17, 1991 · N65418 · Substantial damageNTSB MIA91FA069Accident · 4 fatalField investigationFinal reportBeech 58P · Lantana, FLThe pilot in commands failure to maintain airspeed while performing a go around resulting in the airplane stalling and colliding with the ground in an uncontrolled descent.Jan 17, 1991 · N1802A · DestroyedNTSB DEN91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Crowley, TXA power loss due to carburetor ice resulting from the flight instructors failure to use correct engine management procedures. A factor was the rough terrain in which the forced landing was performed.Jan 17, 1991 · N94330 · Substantial damageNTSB SEA91FA261Accident · No injuriesField investigationFinal reportBeech 35 · Walla Walla, WAImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter. Improper installation of the trim tabs and an encounter with turbulence were related factors.Jan 16, 1991 · N3081V · Substantial damageNTSB MIA91LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · New Smyrna Bch, FLFailure of the CFI to maintain clearance between the right wing tip and a telephone pole.Jan 16, 1991 · N215ER · Substantial damageNTSB LAX91LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Arcadia, CAImproper installation of the recently overhauled powerplant by maintenance personnel and inadequate inspection by maintenance personnel which failed to detect that the engine fuel pressure gauge line was not properly secured to the fuel system manifold valve.Jan 16, 1991 · N9541C · Substantial damageNTSB DEN91LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Houston, TXThe flight instructor's delay in taking remedial action, his inadvertently allowing the airplane to stall, and exceeding the aircraft's climb performance. Factors were: the flight instructor's lack of experience in aircraft type, his lack of experience as a…Jan 16, 1991 · N32108 · Substantial damageNTSB SEA91LA042Accident · No injuriesLimited investigationFinal reportBeech 58P · Chelan, WAThe pilot's failure to maintain directional control during landing roll. A factor was the patchy ice on the runway.Jan 15, 1991 · N3826K · Substantial damageNTSB NYC91LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, WVTotal loss of engine power in cruise flight due to failure of the accessory drive gear dowel pin resulting in a forced landing over unsuitable terrain and subsequent nose over on landing roll. A factor related to the accident was the improper procedure used…Jan 15, 1991 · N62960 · Substantial damageNTSB LAX91FA074Accident · 1 fatalField investigationFinal reportCessna 172RG · Hayward, CAThe pilot's failure to maintain altitude. Contributing factors related to the pilot's improper VFR procedures and his misjudged evaluation of the weather in daylight conditions. Additional factors related to the presence of low clouds and to the restricted…Jan 15, 1991 · N9721B · DestroyedNTSB FTW91FA030Accident · 4 fatalField investigationFinal reportMooney 20J · Newcastle, OKThe pilot's failure to maintain aircraft control. Factors were spatial disorientation, improper IFR procedures, and the dark night with low ceilings and rain.Jan 15, 1991 · N7201E · DestroyedNTSB CHI91LA071Accident · 1 fatalLimited investigationFinal reportMooney M20K · Fayette, MOThe failure of the pilot to maintain control of the airplane. Factors were the pilot's overconfidence in his personal ability, and flight into known adverse weather.Jan 15, 1991 · N5809A · DestroyedNTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…Jan 15, 1991 · UNREG · DestroyedNTSB BFO91LA023Accident · Serious injuriesLimited investigationFinal reportHolmes Special S2C · Ellendale, DEThe pilot's failure to recover from an aerobatic manuever in time to avoid inflight collision with the ground.Jan 15, 1991 · N484MH · DestroyedNTSB ANC91IA020Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nome, AKWas the sheared fitting on the nose gear actuator shuttle valve which caused the nose gear to not extend for landing.Jan 15, 1991 · N4118G · Minor damageNTSB MIA91WA066Accident · 1 fatalForeign investigationCessna U206F · MontserratJan 14, 1991 · N9530G · DestroyedNTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.Jan 14, 1991 · N1361P · Substantial damage