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 NYC89LA110Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Farmingdale, NYPilot's failure to control the altitude of the helicopter while demonstrating a quick stop maneuver to a student.NTSB MIA89LA117Accident · No injuriesLimited investigationFinal reportLee, David Velocity · Ponte Vedra Bch, FLFailure through an oversight to remove the canard gap seals prior to aggravated stall testing which resulted in the aircraft entering an uncontrollable flight regime.NTSB MIA89IA118Incident · No injuriesIncident investigationFinal reportCessna P206B · West Palm Beach, FLFailure of the throttle control arm resulting in the loss of engine power. The failure was caused by poor maintenance.NTSB LAX89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mesa, AZInadequate visual lookout by the pilot, and his failure to maintain the proper altitude. Factors related to the accident were: the pilot's lack of visual perception at dusk, the transmission line, and the obstructions (tree & fence) in the emergency landing…NTSB FTW89FA074Accident · 1 fatalField investigationFinal reportCessna 421 · Brownsville, TXThe pilot's improper emergency procedure after lossing power in the right engine, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: fuel starvation of the right engine,…NTSB ATL89LA118Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Danville, GAThe pilot delayed in applying carburetor heat after the engine began to lose power, and his selection of unsuitable terrain for a precautionary-landing site.NTSB MIA89LA116Accident · Minor injuriesLimited investigationFinal reportBeech B55 · Sarasota, FLUneven runway condition (sunken spot).NTSB LAX89LA139Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Santa Barbara, CAThe improper inflight planning/decisions by the plt when he decided to intentionally fly low over rough water in the pacific ocean and the partial loss of power for undetermined reasons.NTSB LAX89FA137Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Whitmore, CAThe pilot's decision to continue VFR flight with known forecast IMC along his route.NTSB FTW89FA073Accident · 4 fatalField investigationFinal reportCessna 172XP · Hondo, TXThe pilot's decision to depart into known adverse weather and his lack of instrument training and experience.NTSB DEN89LA096Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, COThe pilot's inadequate compensation for wind conditions, failing to maintain directional control, and inadvertent ground swerve. Gusty crosswinds contributed to the accident.NTSB CHI89FA064Accident · 1 fatalField investigationFinal reportCessna 150L · Clawson, MIThe pilot allowing the airspeed to decay below the airplanes stall speed.NTSB ANC89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Beluga Mountain, AKPilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor.NTSB NYC89FA106Accident · No injuriesField investigationFinal reportSikorsky S-76A · Manhattan, NYThe pilot of the other helicopter misjudged clearance between his and the other helicopter. Factors related to the accident were: inadequate layout (markings) of the heliport parking area, insufficient standard/requirement for numerical indication of maximum…NTSB FTW89LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Contributing factors were: inadequate supervision by the CFI, who authorized the 2nd solo flight in unfavorable wind conditions, the…NTSB DEN89LA095Accident · No injuriesLimited investigationFinal reportBeech F33A · Lamar, COFailure of an alternator bearing which resulted in total loss of electrical power after the battery became discharged, and failure of the pilot to insure the gear was fully extended during a precautionary landing. The pilot's lack of familiarity with the gear…NTSB CHI89DEP02Accident · No injuriesFinal reportCessna 172M · West Bend, WIPartial failure of the throttle cable. Unsuitable (soft) terrain and transmission wires in the landing area were considered to be factors.NTSB ATL89LA117Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Timmonsville, SCThe pilot's failure to remain aware of the local wind conditions. Additionally, he executed the approach and landing with excessive speed, combined with a tailwind, which resulted in the runway overrun.NTSB ATL89FA116Accident · 2 fatalField investigationFinal reportMBB BK-117-A-3 · Coinjock, NCFailure of the cellular company to properly install an operational lighting system on a newly constructed transmission tower. Darkness and the company's failure to notify flight service of the unlighted tower were related factors.NTSB SEA89LA062Accident · No injuriesLimited investigationFinal reportCessna 185 · Everett, WAThe failure of the pilot to maintain directional control of the tailwheel aircraft during landing roll.NTSB NYC89LA109Accident · No injuriesLimited investigationFinal reportCessna 172XP · Vineland, NJThe pilot's misjudgement of speed & distance during landing which resulted in the proper touchdown point to be exceeded. The runway conditions were contributing factors.NTSB NYC89FA105Accident · 4 fatalField investigationFinal reportAerospatiale TB-10 · Pittsfield, MAFailure of the pilot to maintain proper altitude. Factors related to the accident were: inadequate briefing provided by the flight service station (fss) specialist, dark night, low clouds, and terrain conditions.NTSB MKC89LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Papillion, NEThe contamination of the fuel screen by foreign matter and operation of the aircraft with known deficiencies.NTSB LAX89FA136Accident · No injuriesField investigationFinal reportAerospatiale AS-355-F · Bear Valley, CAImproper in-flight planning/decision by the pilot, which resulted in a loss of aircraft control during a slow speed, downwind approach to a high altitude stolport. Contributing factors were: high density altitude, tailwind, improper weather evaluation by the…NTSB LAX89FA133Accident · 4 fatalField investigationFinal reportMooney M20F · San Andreas, CAInterruption of engine power for an undetermined reason, and failue of the pilot to maintain airspeed, which resulted in a stall/spin. A factor related to the accident was: lack of altitude to recover from the stall/spin.NTSB CHI89LA063Accident · Minor injuriesLimited investigationFinal reportBeech 95-B-55 · Crothersville, INA failure of the engine due to a crankshaft counterweight failure. The pilot performed emergency procedures and executed a forced landing in an open field, where the aircraft encountered a large muddy area, bogged down and nosed over.NTSB ATL89LA115Accident · No injuriesLimited investigationFinal reportBeech B24R · New Carlisle, OHThe pilot's failure to clear the trees after the in-flight collision with an undetermined object. He allowed the altitude to decrease to the point of colliding with trees before initiating remedial action to maintain flight and land the airplane.NTSB ATL89FA114Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Covington, GAInadequate preflight by the pilot by inadvertently allowing the carburetor heat to be in the 'hot' position for takeoff. The high density altitude and trees were considered to be contributing factors.NTSB SEA89LA059Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Rosalia, WAA loss of engine power due to a supercharger failure. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB MKC89LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Advance, MOThe pilot's inadequate visual lookout resulting in his failure to see power lines in time to avoid them. Contributing to the accident was the reduced visibility due to fog.NTSB MIA89LA114Accident · Minor injuriesLimited investigationFinal reportDyar KIT FOX · Purvis, MSFailure of the engine's rear piston. Factors related to the accident were: the pilot's lack of altitude for a forced landing and trees in the emergency landing area.NTSB MIA89FA115Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Daytona Bch Shr, FLIn-flight loss of control while maneuvering to reverse direction due the failure of the pilot to maintain adequate airspeed during the 'steep turn.'NTSB FTW89DRA03Accident · No injuriesFinal reportBenson B-8-M · La Porte, TXHard landing which occurred as a result of the pilot having to extend his glide over obstacles on short final to the forced landing area. The forced landing was executed as a result of engine performance degradation due to induction icing for which no…NTSB DEN89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Great Falls, MTThe failure of the pilot in compensate adequately for wind conditions, and landing despite having been alerted to wind conditions.NTSB DEN89FA093Accident · 2 fatalField investigationFinal reportCessna 177RG · Albuquerque, NMThe pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control.NTSB ATL89DLG01Accident · No injuriesFinal reportUpchurch Rotorway Executive · Lugoff, SCImproper evaluation of existing conditions during preflight inspection resulting in a dynamic rollover due to drag from an imbedded left skid.NTSB ANC89LA054Accident · No injuriesLimited investigationFinal reportCessna 180-A · Skwentna, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. A contributing factor to the accident is the pilot's selection of an unsuitable landing/takeoff site.NTSB NYC89LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Pittstown, NJImproper inflight planning which led to engine failure due to fuel exhaustion.NTSB NYC89IA107Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Albany, NYThe crew's failure to use full engine anti-ice systems which resulted in ice blocking the engine inlets.NTSB MKC89LA084Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Dodge, IAThe failure of the pilot to adequately compensate for existing wind conditions, to flare properly, and to recover properly from a bounced landing. The gusty x-wind conditions contributed to the accident.NTSB MKC89FA083Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Mayflower, ARThe pilots failure to maintain airspeed (vs), and inadvertant entry into a stall with necessary remedial action not understood.NTSB LAX89LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Lake Elsinore, CACFI displayed poor judgement in his demonstration of single engine operation of a twin engine acft. His lack of supervision of an improper, deteriorating situation assured an unsuccessful conclusion.NTSB LAX89LA134Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Phoenix, AZLoss of control due to inadequate preflight and control interference.NTSB LAX89LA132Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Oceanside, CAThe failure of the student pilot to compensate adequately for wind conditions and to relinquish the flight controls to the instructor. Contributing to the accident was inadequate supervision by the instructor.NTSB FTW89LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Lake Arthur, LAThe failure of the pilot to see and avoid tree limbs that extended over the edge of the canal. Factors related to the accident were: the tree limbs and dirt bank near the edge of the selected landing area.NTSB BFO89FA024Accident · No injuriesField investigationFinal reportLearjet 25 · Roanoke, VACo-pilots poorly planned approach which resulted in an overrun landing. A contributing factor was the captains poor supervision of the approach and landing.NTSB MIA89FA113Accident · 1 fatalField investigationFinal reportPiper Aerostar 600 · Jacksonville, FLImproper use of the IFR procedure by the pilot, his failure to maintain a proper glide path, and his failure to identify the decision height.NTSB FTW89LA069Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Catoosa, OKCarburetor ice and improper use of carburetor heat. Factors related to the occurrence were: carburetor icing conditions and rough/uneven terrain.NTSB FTW89IA070Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Houston, TXCrew's failure to follow taxi instructions and to insure that they were on the proper runway prior to initiation of the takeoff roll.NTSB DEN89LA092Accident · Serious injuriesLimited investigationFinal reportPoehls Bobcat · Billings, MTThe pilot inadvertently stalled the aircraft at an altitude which was too low to permit recovery.