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 DEN90LA079Accident · No injuriesLimited investigationFinal reportCessna 172M · Colorado Spring, COThe pilot's decision to initiate flight into known adverse weather, and his in-flight planning/decison. Factors related to the accident were: the adverse weather conditions, and the accumulation of airframe ice.NTSB DEN90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T210J · Englewood, COThe pilot's loss of directional control during an aborted takeoff.NTSB CHI90LA104Accident · No injuriesLimited investigationFinal reportCessna 150M · Indianapolis, INFailure of pilot-in-command to adequately compensate for wind conditions which resulted in a loss of aircraft control. The unfavorable wind conditions (windshear, crosswind & turbulence) were related factors.NTSB ATL90IA087Incident · No injuriesIncident investigationFinal reportMooney M-20L · Augusta, GAThe reported performance problem during climbout was undetermined. The pilot's decision to land with the landing gear retracted contributed to the minor damage sustained.NTSB SEA90LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Yamhill, ORThe pilot's failure to use the proper touchdown point for landing. The tailwind was a factor related to the accident.NTSB NYC90LA080Accident · No injuriesLimited investigationFinal reportCessna CE-172P · Hollidaysburg, PAPilot factor in that he failed to ensure there was sufficient fuel on board to complete the flight. This resulted in an engine failure & subsequent forced landing.NTSB MIA90LA094Accident · No injuriesLimited investigationFinal reportBeech B-19 · Everglades City, FLThe pilots failure to flare the aircraft for landing resulting in the nose landing gear contacting the runway causing it to separate.NTSB LAX90LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Livermore, CAThe failure of the pilot to anticipate the carburetor icing conditions and to take the appropriate precautions.NTSB CHI90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Wausau, WIA hard landing resulting from the pilot not taking timely remedial when a stall was encountered.NTSB CHI90LA102Accident · No injuriesLimited investigationFinal reportRobinson R22 · Phillipsburg, OHThe failure of the pilot to retain control of the aircraft.NTSB ANC90FA042Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Wasilla, AKThe failure of the PIC to maintain sufficient airspeed to preclude a stall.NTSB SEA90LA055Accident · No injuriesLimited investigationFinal reportPiper PA18-160 · Reno, NVThe pilot failed to maintain directional control during landing roll.NTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.NTSB MKC90LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Concordia, MOInadequate pre-flight planning and preparation, misjudged fuel consumption calculations and re-fueling not performed by the pilot in command.NTSB FTW90IA086Incident · No injuriesIncident investigationFinal reportBritish Aerospace HS125-800 · Atlanta, GAThe leaking aft lavatory water heater unit.NTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.NTSB DEN90FA076Accident · 4 fatalField investigationFinal reportCessna 182N · Caputa, SDImproper planning/decision by the pilot, accumulation of structural ice and the pilot's failure to maintain control of the aircraft. The adverrse weather was a related factor.NTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.NTSB ANC90LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot failed to maintain directional control during landing. Contributing factors were the rough terrain, and the pilot's lack of total and recent experience in that model airplane.NTSB FTW90IA085Incident · No injuriesIncident investigationFinal reportCessna Citation SII · Dallas, TXImproper installation of the air conditioning unit, which resulted in an electrical short which caused separation of an elevator control cable.NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.NTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.NTSB SEA90LA054Accident · 1 fatalLimited investigationFinal reportde Havilland DH 82A · White City, ORPilot's delay in taking remedial action to prevent an undershoot. His misjudgement of distance and altitude on final approach were related factors.NTSB MKC90LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Minneapolis, MNAircraft control not maintained by the pilot in command. His lack of experience in the type of aircraft was a factor.NTSB CHI90LA100Accident · No injuriesLimited investigationFinal reportCessna 150B · Shelbyville, INThe private pilot's failure to maintain directional control of the aircraft during the landing. The crosswind was a related factor.NTSB ANC90FA040Accident · No injuriesField investigationFinal reportCessna A185E · Alexander Lake, AKLoss of engine power for an unknown reason. Factors related to the accident were: darkness and trees in the emergency landing area.NTSB MKC90LA073Accident · No injuriesLimited investigationFinal reportBeech B35 · Hartington, NEDirectional control not maintained by the pilot in command.NTSB LAX90LA129Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Tehachapi, CAA loss of engine power for undetermined reason(s).NTSB LAX90FA123Accident · 1 fatalField investigationFinal reportCessna 172N · Buena Park, CAThe pilot not maintaining the prescribed minimum descent altitude during an instrument approach.NTSB FTW90LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pearland, TXDynamic rollover resultant from improper takeoff techniques used by the rated pilot, and inadequate supervision by the company check pilot.NTSB CHI90LA098Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Greenfield, INThe pilots selection of the wrong runway relative to the wind and his failure to go-around in a timely manner.NTSB SEA90LA053Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Juneau, AKThe pilot did not maintain directional control of the airplane during the initial climb and did not adequately correct the situation prior to colliding with an object.NTSB NYC90LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Andover, NJThe pilot failed to maintain control of the aircraft after encounter with turbulence during landing.NTSB MKC90DPG01Accident · Serious injuriesFinal reportVolksplane WE-1 · Wooster, ARThe power loss for undetermined reasons and the inadvertent stall. A factor was the pilot's maximum performance takeoff.NTSB MIA90LA092Accident · Minor injuriesLimited investigationFinal reportTalmadge Scott Longez · St. Petersburg, FLThe failure of maintenance personnel to properly secure the carburetor throttle cable housing.NTSB LAX90LA121Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Canyon Lake, CAThe pilot to maintain proper rotor RPM during a practice autorotation. Contributing to the accident was the uneven terrain selected by the pilot to conduct practice touch maneuvers.NTSB LAX90DUG04Accident · 2 fatalFinal reportWeber Christen Eagle II · Bermuda Dunes, CAThe pilot-in-command's improper use of the flight controls while performing acrobatic maneuvers.NTSB DEN90LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkhorn, MTThe pilot's decision to attempt flight in terrain and conditions which exceeded the performance capabilities of the airplane.NTSB ATL90LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, NCThe pilot's delayed pull up from an intentional descent during an aborted suicide attempt.NTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.NTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.NTSB MIA90FA091Accident · 2 fatalField investigationFinal reportWohlers Steen/Skybolt · Quincy, FLInflight loss of control for undetermined reasons.NTSB LAX90LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · Santa Ana, CAThe pilot's improper rotation during takeoff.NTSB FTW90LA084Accident · No injuriesLimited investigationFinal reportCessna 172G · Rio Hondo, TXOil starvation induced power loss due to improper maintenance procedures. Contributing to the accident were inadequate maintenance inspection and the soft terrain in which the forced landing was performed.NTSB CHI90LA099Accident · No injuriesLimited investigationFinal reportPiper PA28R · Chicago, ILFailure of the pilot to maintain control of the accident airplane during an attempted landing.NTSB CHI90DEV02Accident · Serious injuriesFinal reportPiper PA-25-150 · Sullivan, ILThe pilot-in-command's failure to maintain adequate terrain clearance during a turn at low altitude, resulting in ground collision. Contributing to the severity of the pilot's injury was his failure to use the installed shoulder harness.NTSB BFO90FA032Accident · 2 fatalField investigationFinal reportCessna 172N · Bedford, VAThe pilot's decision to fly into known adverse weather conditions and his failure to maintain clearance above the terrain. Contributing to the accident was the pilot's self induced pressure, low ceilings, mountainous terrain and rain.