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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW91LA051Accident · No injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB 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.NTSB 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.NTSB 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.NTSB BFO91FA031Accident · Serious injuriesField investigationFinal reportCessna 182F · Princeton, WVThe pilot's inadequate inflight decision which resulted in airframe icing.NTSB 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.NTSB NYC91LA089Accident · No injuriesLimited investigationFinal reportCessna 150J · Angola, NYThe failure of the pilot to insure the magneto switch was off prior to moving the propeller.NTSB 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 ravineNTSB 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.NTSB 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.NTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC91LA035Accident · No injuriesLimited investigationFinal reportCessna 180K · Amos Lakes, AKThe pilot's selection of terrain that was rough, snow-covered and icy for takeoff.NTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.NTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.NTSB NYC91LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe instructor pilot's failure to maintain control of the airplane during landing in a strong crosswind.NTSB 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…NTSB 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.NTSB SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.NTSB 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.NTSB LAX91FA124Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Palm Springs, CAIncapacitation of the pilot due to inadequate sleep.NTSB 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…NTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.NTSB ANC91LA033Accident · No injuriesLimited investigationFinal reportCessna A185-F · Shageluk, AKThe collapse of the left main landing gear during the landing roll due to preexisting cracks.NTSB 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.NTSB 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…NTSB 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.NTSB MIA91WA093Accident · No injuriesForeign investigationPiper PA-31P · Atlantic Ocean (Atlantic Ocean)NTSB BFO91LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Hagerstown, MDThe failure of the throttle control cable. A factor ws the rough terrain.NTSB 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.NTSB 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…NTSB 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.