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 BFO91DOA01Accident · Minor injuriesFinal reportBell UH-1B · Iaeger, WVThe loss of engine power for undetermined reasons, while operating over unsuitable terrain.Jul 1, 1991 · N91348 · Substantial damageNTSB ATL91LA037Accident · No injuriesLimited investigationFinal reportBeech T-34B · Cartersville, GAThe dual student allowed the airplane to stall because of improper use of the throttle, which resulted in a touch down short of the proper point. A factor in the accident was the inadequate supervision by the flight instructor.Jul 1, 1991 · N96065 · Substantial damageNTSB ATL91FA120Accident · 1 fatalField investigationFinal reportHughes 269C · Blakely, GALoss of engine power for an undetermined reason, and failure of the instructor pilot (CFI) to follow procedures and maintain rotor RPM.Jul 1, 1991 · N11017 · Substantial damageNTSB ANC91LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKWas the pilot-in-command's loss of control during the takeoff run, thereby allowing the airplane to stray from the runway's centerline and to strike some high vegetation.Jul 1, 1991 · N1476C · Substantial damageNTSB ANC91LA085Accident · No injuriesLimited investigationFinal reportBell 206BIII · Sheep Mountain, AKThe pilot's lack of compensation for wind conditions and continued operation with the wind in the 'critical wind azimuth' area which led to limited tail rotor authority. Contributing to the accident was the variable and gusty wind conditions.Jul 1, 1991 · N302MH · Substantial damageNTSB NYC91LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · Lancaster, NYThe failure of an engine exhaust valve, which resulted in a loss of engine power and a forced landing on unsuitable terrain.Jun 30, 1991 · N89209 · Substantial damageNTSB MIA91WA176Accident · 6 fatalForeign investigationCessna U206 · Missing, BahamasJun 30, 1991 · N90236 · DestroyedNTSB LAX91LA283Accident · No injuriesLimited investigationFinal reportBoeing E75 · San Luis Obispo, CAThat the pilot failed to properly compensate of the existing quartering tailwind, improperly using the flight controls and brakes.Jun 30, 1991 · N68809 · Substantial damageNTSB LAX91FA282Accident · 6 fatalField investigationFinal reportBeech 65 · Pioneer, CAImproper emergency procedures by the pilot, when he inadvertently shut down the left engine after encountering a partial loss of power in the right engine. Factors related to the accident were: improper installation of the right engine's #6 exhaust valve seat…Jun 30, 1991 · N713JB · DestroyedNTSB FTW91LA112Accident · No injuriesLimited investigationFinal reportBell 206L-1 · S. Tim 171dThe high rate of descent and delayed flare.Jun 30, 1991 · N2772A · Substantial damageNTSB FTW91LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Clinton, ARThe loss of directional control due to locked wheel brake on the left landing gear.Jun 30, 1991 · N7507B · Substantial damageNTSB DEN91LA093Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COThe pilot's failure to compensate for the crosswind. Factors were: a crosswind condition, and the pilot's total lack of experience.Jun 30, 1991 · N90994 · Substantial damageNTSB CHI91DER10Accident · Serious injuriesFinal reportKolb Twinstar MK II · Staples, MNThe disconnected elevator trim cable. Related factors are the inadequate maintenance/installation, and the pilot's inability to maintain aircraft control.Jun 30, 1991 · N503BP · DestroyedNTSB ANC91LA083Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Louise, AKThe pilot not maintaining directional control during the takeoff roll. Contributing to the accident was the rough condition of the airstrip.Jun 30, 1991 · N4659C · Substantial damageNTSB NYC91LA159Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Manassas, VAThe pilot's improper inflight decision and his failure to maintain proper airspeed at a low altitude which resulted in the helicopter settling with power. A factor in the accident was the pilot's failure to follow prescribed procedures/directives.Jun 29, 1991 · N48323 · Substantial damageNTSB MIA91LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Groveland, FLFailure of the pilot to maintain adequate airspeed resulting in inadvertent stall/mush.Jun 29, 1991 · N46305 · Substantial damageNTSB MIA91LA174Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Brooker, FLFailure of the noncertificated pilot to obtain a weather briefing before departure & failure to maintain directional control after the precautionary landing. Contributing to the accident was lack of suitable terrain.Jun 29, 1991 · N98337 · Substantial damageNTSB LAX91FA280Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-36A · Goleta, CAThe pilot's failure to maintain directional control of the airplane after becoming spatially disoriented. Factors related to the accident were: darkness, low overcast cloud condition, the pilot's decision to continue VFR flight into instrument meteorological…Jun 29, 1991 · N2CJ · DestroyedNTSB FTW91LA113Accident · No injuriesLimited investigationFinal reportCessna A188B · Lewisville, ARThe failure of the right brake line during a critical phase of operation.Jun 29, 1991 · N731KV · Substantial damageNTSB FTW91DPA02Accident · Serious injuriesFinal reportPaul M. F. Walker Pitts S-1-C · Royse City, TXThe pilot's performance of an aerobatic maneuver at an altitude too low to allow recovery.Jun 29, 1991 · N4PW · Substantial damageNTSB DEN91LA092Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Albuquerque, NMThe pilot's improper maintenance of the aircraft. Factors were: a loose oil filter and loss of engine oil.Jun 29, 1991 · N21420 · Substantial damageNTSB CHI91DER11Accident · No injuriesFinal reportPiper OA25-235 · Clinton, MNThe pilot's failure to maintain adequate control of the aircraft while maneuvering in aerial application operations. Related factors are wake turbulence and low altitude.Jun 29, 1991 · N9599P · DestroyedNTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.Jun 29, 1991 · N391KS · Substantial damageNTSB BFO91FA060Accident · 1 fatalField investigationFinal reportPiper J5 · Berlin, MDThe pilot's failure to maintain adeqate airspeed which caused the airplane to stall.Jun 29, 1991 · N763WM · DestroyedNTSB ATL91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Muscle Shoals, ALThe loss of engine power for undetermined reasons.Jun 29, 1991 · N48430 · Substantial damageNTSB ATL91FA117Accident · 2 fatalField investigationFinal reportFuji LM 1 · Keystone Hghts, FLFailure of the number four pilot (in N2100J) to maintain adequate visual lookout and/or clearance from the number three aircraft (N2109L).Jun 29, 1991 · N2109L · 2 aircraft · DestroyedNTSB ANC91LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Blair Lakes, AKWas the pilot-in-command's failure to assure sufficient obstruction clearance for his airplane during the takeoff roll. Contributing to the accident was the high vegetation.Jun 29, 1991 · N5665A · Substantial damageNTSB MIA91LA173Accident · No injuriesLimited investigationFinal reportCessna 172N · Punta Gorda, FLFailure of the pilot to observe the windsock before landing resulting in failure to maintain directional control after landing with a quartering tailwind. The airplane collided with a ditch. Contributing to the accident was lack of total experience of the…Jun 28, 1991 · N6522D · Substantial damageNTSB MIA91FA172Accident · Serious injuriesField investigationFinal reportCessna 411 · North Ft. Myers, FLThe pilot in commands failure to follow emergency procedures and his failure to maintain airspeed following loss of power in one engine resulting in an inadvertent stall and the inflight loss of control with subsequent inflight collision with an object and…Jun 28, 1991 · N4940T · DestroyedNTSB LAX91FA281Accident · 2 fatalField investigationFinal reportCessna 182Q · Fillmore, CAPoor judgement by the pilot to continue VFR flight into instrument meteorological conditions. Contributing to the accident was IFR conditions that included low ceilings and low visibility and insufficient instrument training of the pilot to deal with the IFR…Jun 28, 1991 · N759FY · DestroyedNTSB FTW91LA110Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Addison, TXEntry door opening in flight, inadequate emergency procedures published by the manufacturer, and poor emergency training by the student's instructor. Factors were inadequate design/installation of the door locking mechanism, deteriorated airplane performance,…Jun 28, 1991 · N18989 · Substantial damageNTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.Jun 28, 1991 · N91108 · DestroyedNTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.Jun 28, 1991 · N88142 · Substantial damageNTSB CHI91DER08Accident · 1 fatalFinal reportBellanca 8GCBC · St. Hilaire, MNThe pilot's failure to maintain sufficient altitude while maneuvering.Jun 28, 1991 · N8714V · DestroyedNTSB ANC91LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Whittier, AKThe pilot's failure to maintain proper flying speed.Jun 28, 1991 · N4362V · DestroyedNTSB SEA91FA143Accident · Serious injuriesField investigationFinal reportSikorsky S-64E · Index, WAThe control interference by the mechanic when he inadvertently raised the collective pitch and the copilot's failure to attend the flight controls. Factors relating to the accident were the motion sickness of the mechanic, inadequate collective pitch control…Jun 27, 1991 · N6959R · DestroyedNTSB LAX91LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Flagstaff, AZFailure of the pilot-in-command to properly lock the engine primer control which resulted in an over rich fuel to air mixture and subsequent loss of engine power.Jun 27, 1991 · N1898J · Substantial damageNTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.Jun 27, 1991 · N541FL · Substantial damageNTSB ANC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of control during the takeoff sequence caused by the failure of the tail wheel steering spring. Factors contributing to the accident were the gusty wind conditions and soft terrain.Jun 27, 1991 · N6908K · Substantial damageNTSB SEA91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakima, WAThe loss of control by the private pilot and failure of the instructor pilot to perform remedial action.Jun 26, 1991 · N7369D · Substantial damageNTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.Jun 26, 1991 · N7859S · Substantial damageNTSB NYC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYThe failure of the pilot to attain the proper airspeed during an aborted landing, which resulted in a stall and loss of airplane control. Factors related to the accident were: the loss of directional control during landing, and the lack of recent flight…Jun 26, 1991 · N55149 · Substantial damageNTSB NYC91LA157Accident · Minor injuriesLimited investigationFinal reportMaule M6 · Lake Placid, NYThe failure of the pilot to properly compensate for the winds which resulted in a loss of control during landing. Factors related to the accident were: control interference from a passenger and gusty crosswinds.Jun 26, 1991 · N56476 · Substantial damageNTSB NYC91LA156Accident · No injuriesLimited investigationFinal reportBoeing PT-17A75N1 · Limington, METhe improper handling of the airplane while taxiing, which resulted in a loss of control. A factor was the limited experience of the pilot in this model.Jun 26, 1991 · N422S · Substantial damageNTSB MIA91LA170Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Falcon, MSIn flight encounter with weather, high density altitude. Contributing to the accident was aircraft gross weight which was exceeded.Jun 26, 1991 · N8942H · Substantial damageNTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.Jun 26, 1991 · N3629X · Substantial damageNTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.Jun 26, 1991 · N60195 · DestroyedNTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.Jun 26, 1991 · N8460E · DestroyedNTSB DEN91LA091Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Vail, COA severe downdraft. A factor was: the pilot's failure to obtain a weather briefing.Jun 26, 1991 · N45747 · Substantial damageNTSB CHI91LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Big Rapids, MIThe stall/mush which occurred during the go-around. A factor related to the accident was the pilot's abrupt pull-up maneuver.Jun 26, 1991 · N51306 · Substantial damage