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 FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.Mar 16, 1991 · N23535 · DestroyedNTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.Mar 16, 1991 · N78195 · Substantial damageNTSB ATL91LA066Accident · 1 fatalLimited investigationFinal reportBenson B8M · Hartselle, ALThe improper installation of the main rotor bearing block by the owner/pilot which resulted in the separation of the main rotor system.Mar 16, 1991 · N6572K · Substantial damageNTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.Mar 15, 1991 · N73135 · Substantial damageNTSB LAX91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Eloy, AZThe student pilot's improper recovery from a bounced landing and the inadvertent entry into a porpoise condition.Mar 15, 1991 · N5496B · Substantial damageNTSB FTW91LA051Accident · No injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.Mar 15, 1991 · N36DB · Substantial damageNTSB MIA91LA099Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Panama City, FLCarburetor icing due to improper use of carburetor heat by the pilot, resulting in a forced landing and ditching.Mar 14, 1991 · N88FP · Substantial damageNTSB MIA91LA098Accident · No injuriesLimited investigationFinal reportElliott Emeraude · Eustis, FLExcessive elevator control input by the PIC while his attention was diverted, inattentiveness to the airspeed (vs), and inadvertent stall while on approach to land.Mar 14, 1991 · N31HE · DestroyedNTSB CHI91LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Flushing, MIThe pilot's failure to attain proper runway alignment and not maintaining directional control which resulted in a ground loop. Factors relating to this accident were the gusty crosswind conditions which existed at the time.Mar 14, 1991 · N1406K · Substantial damageNTSB BFO91FA031Accident · Serious injuriesField investigationFinal reportCessna 182F · Princeton, WVThe pilot's inadequate inflight decision which resulted in airframe icing.Mar 14, 1991 · N3529Y · DestroyedNTSB ATL91FA064Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Lawrenceville, GAThe poor inflight planning by the pilot which resulted in fuel exhaustion. Factors related to this accident were the unfavorable winds, the dark night, and the inoperable airport runway lights.Mar 14, 1991 · N9191P · Substantial damageNTSB NYC91LA089Accident · No injuriesLimited investigationFinal reportCessna 150J · Angola, NYThe failure of the pilot to insure the magneto switch was off prior to moving the propeller.Mar 13, 1991 · N51396 · Substantial damageNTSB MIA91LA097Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hattiesburg, MSOn ground encounter with a wind gust and failure of the pilot to maintain directional control of the airplane during the landing roll, resulting in the collision with a ravineMar 13, 1991 · N735MK · Substantial damageNTSB LAX91FA133Accident · 3 fatalField investigationFinal reportCessna 320D · Gorman, CAVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude/clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions.Mar 13, 1991 · N3302Q · DestroyedNTSB NYC91LA088Accident · No injuriesLimited investigationFinal reportPiper PA28-400 · Fall River, MAAn improper flare and touchdown point which resulted in an overrun of the runway during the landing roll.Mar 12, 1991 · N8452P · Substantial damageNTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.Mar 12, 1991 · N69095 · Substantial damageNTSB NYC91FA086Accident · Minor injuriesField investigationFinal reportDouglas DC-8-62 · Jamaica, NYImproper preflight planning/preparation, in that the flight engineer miscalculated (misjudged) the aircraft's gross weight by 100,000 lbs and provided the captain with improper takeoff speeds; and improper supervision by the captain. Factors related to the…Mar 12, 1991 · N730PL · DestroyedNTSB MIA91LA113Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Vero Beach, FLImproper maintenance adjustment by company maintenance personnel resulting in overtorque of a tailboom attach bolt which allowed the tailboom to shift. This disengaged the tail rotor drive shaft at a coupling resulting in the loss of tail rotor drive.Mar 12, 1991 · N9687R · Substantial damageNTSB MIA91LA096Accident · 1 fatalLimited investigationFinal reportBartholomew Kolb Twinstar · Bronson, FLPilot-in-command's decision to initiate a flight with known deficiencies in his equipment in that his airspeed indicator was inoperative. He then failed to maintain airspeed in a turn on final approach, stalled, and crashed.Mar 12, 1991 · N860RB · DestroyedNTSB LAX91LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAThe pilot's improper inflight planning which resulted in the flight's encounter with wake turbulence from a landing heavy transport.Mar 12, 1991 · N757XE · DestroyedNTSB LAX91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Tucson, AZThe fatigue failure of the right engine turbo exhaust clamp, and, the failure of the flying pilot to complete the single engine emergency procedures in a timely manner. A factor in the accident was the failure of the pilot in command to adequately supervise…Mar 12, 1991 · N924MD · Substantial damageNTSB CHI91LA106Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ogallala, NEImproper planning/decision by the pilot and the lack of sufficient airspeed to maneuver (circle to land) in unfavorable wind conditions with structural ice on the aircraft. The adverse weather conditions and structural (wing) ice were related factors.Mar 12, 1991 · N6687U · DestroyedNTSB ATL91LA065Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dunlap, TNFailure of the pilot to maintain control of the aircraft, which resulted in a ground loop/swerve. The crosswind was a related factor.Mar 12, 1991 · N42013 · Substantial damageNTSB SEA91LA066Accident · No injuriesLimited investigationFinal reportHughes 369D · Roseburg, ORA loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for an emergency landing.Mar 11, 1991 · N1088L · Substantial damageNTSB ANC91LA034Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Atigan Pass, AKThe pilot continued to fly VFR into IFR conditions. Related to the accident were: low ceilings, whiteout conditions, and the mountainous terrain.Mar 11, 1991 · N77316 · Substantial damageNTSB SEA91LA064Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Loa, UTThe pilot-in-command's failure to maintain airspeed on takeoff climb in a turn resulting in an inadvertnent stall and subsequent in flight collision with terrain. Contributing to the accident was a crosswind with gusts.Mar 10, 1991 · N7108U · Substantial damageNTSB MIA91FA095Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Key West, FLThe pilot-in-command's failure to maintain airspeed, while returning for an emergency landing following propeller failure, resulting in the aircraft stalling and entering a spin.Mar 10, 1991 · N4828J · DestroyedNTSB LAX91LA128Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Farmington, CAThe contamination of the engine induction air filter. Soft terrain during the touchdown was a factor in the accident.Mar 10, 1991 · N59403 · Substantial damageNTSB DEN91LA050Accident · No injuriesLimited investigationFinal reportBeech V35B · Englewood, COThe pilot's premature liftoff and inadvertent stall mush. Factors were: downdrafts, high density altitude, and unsuitable terrain.Mar 10, 1991 · N9038Q · DestroyedNTSB DEN91FA049Accident · 2 fatalField investigationFinal reportBeech F33A · Sterling, COPoor judgement of the pilot and his misjudgement of altitude while buzzing over glassy water. His lack of visual ques to judge altitude over glassy water was a related factor.Mar 10, 1991 · N4179S · DestroyedNTSB ANC91LA035Accident · No injuriesLimited investigationFinal reportCessna 180K · Amos Lakes, AKThe pilot's selection of terrain that was rough, snow-covered and icy for takeoff.Mar 10, 1991 · N66036 · Substantial damageNTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.Mar 9, 1991 · N64599 · Substantial damageNTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.Mar 9, 1991 · N3163N · Substantial damageNTSB NYC91LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe instructor pilot's failure to maintain control of the airplane during landing in a strong crosswind.Mar 9, 1991 · N64937 · Substantial damageNTSB MIA91LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greenwood, MSFailure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…Mar 9, 1991 · N2949J · Substantial damageNTSB LAX91LA127Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIInaccurate fuel consumption calculation by the pilot. A factor was the partial deflation of the emergency flotation equipment.Mar 9, 1991 · N2072C · DestroyedNTSB SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.Mar 8, 1991 · N5095P · Substantial damageNTSB LAX91LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZEngine failure due to oil starvation caused by a rotation of the main bearing. A factor in the accident was the failure of the operator maintenance personnel to accomplish an engine overhaul within the interval specified by the manufacturer.Mar 8, 1991 · N69116 · Substantial damageNTSB LAX91FA124Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Palm Springs, CAIncapacitation of the pilot due to inadequate sleep.Mar 8, 1991 · N711PE · DestroyedNTSB FTW91LA048Accident · 1 fatalLimited investigationFinal reportBell 206B II · High Island, TXFor occurrence #1 - inadequate supervision by the operator in launching a hazardous mission without an adequate sling/harness, the pilot's poor judgement in accepting and continuing the mission into low light conditions, and the crewmember's inadvertent…Mar 8, 1991 · N59491 · Substantial damageNTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.Mar 8, 1991 · N8189V · Substantial damageNTSB ANC91LA033Accident · No injuriesLimited investigationFinal reportCessna A185-F · Shageluk, AKThe collapse of the left main landing gear during the landing roll due to preexisting cracks.Mar 8, 1991 · N1855Q · Substantial damageNTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.Mar 8, 1991 · N756XE · Minor damageNTSB NYC91LA084Accident · Minor injuriesLimited investigationFinal reportCessna 210 · East Swanzey, NHThe pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…Mar 7, 1991 · N747IE · Substantial damageNTSB NYC91LA083Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Rancocas, NJThe pilot-in-command failed to maintain airspeed on initial take off climb resulting in a stall and in flight collision with terrain. Contributing to the accident was a loss of engine power for undetermined reason and a gusty crosswind condition.Mar 7, 1991 · N74994 · Substantial damageNTSB MIA91WA093Accident · No injuriesForeign investigationPiper PA-31P · Atlantic Ocean (Atlantic Ocean)Mar 7, 1991 · N666SC · Substantial damageNTSB BFO91LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Hagerstown, MDThe failure of the throttle control cable. A factor ws the rough terrain.Mar 7, 1991 · N6699P · Substantial damageNTSB SEA91FA061Accident · 3 fatalField investigationFinal reportCessna 172M · Bellingham, WAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or cleareance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and terrain conditions.Mar 6, 1991 · CGJNM · DestroyedNTSB SEA91FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Bellingham, WAVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or clearance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and…Mar 6, 1991 · CGIXI · DestroyedNTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.Mar 6, 1991 · N76553 · Substantial damage