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 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.Mar 25, 1990 · N19948 · Substantial damageNTSB DEN90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T210J · Englewood, COThe pilot's loss of directional control during an aborted takeoff.Mar 25, 1990 · N2KD · Substantial damageNTSB 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.Mar 25, 1990 · N66258 · Substantial damageNTSB 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.Mar 25, 1990 · N1024Z · Minor damageNTSB 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.Mar 24, 1990 · N1122R · Substantial damageNTSB 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.Mar 24, 1990 · N62274 · Substantial damageNTSB 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.Mar 24, 1990 · N24613 · Substantial damageNTSB LAX90LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Livermore, CAThe failure of the pilot to anticipate the carburetor icing conditions and to take the appropriate precautions.Mar 24, 1990 · N60025 · Substantial damageNTSB CHI90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Wausau, WIA hard landing resulting from the pilot not taking timely remedial when a stall was encountered.Mar 24, 1990 · N2331C · Substantial damageNTSB CHI90LA102Accident · No injuriesLimited investigationFinal reportRobinson R22 · Phillipsburg, OHThe failure of the pilot to retain control of the aircraft.Mar 24, 1990 · N80450 · Substantial damageNTSB ANC90FA042Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Wasilla, AKThe failure of the PIC to maintain sufficient airspeed to preclude a stall.Mar 24, 1990 · N68596 · Substantial damageNTSB SEA90LA055Accident · No injuriesLimited investigationFinal reportPiper PA18-160 · Reno, NVThe pilot failed to maintain directional control during landing roll.Mar 23, 1990 · N9977Q · Substantial damageNTSB 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.Mar 23, 1990 · N4490X · Substantial damageNTSB 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.Mar 22, 1990 · N3650J · Substantial damageNTSB FTW90IA086Incident · No injuriesIncident investigationFinal reportBritish Aerospace HS125-800 · Atlanta, GAThe leaking aft lavatory water heater unit.Mar 22, 1990 · N802X · No damageNTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.Mar 22, 1990 · N2331X · Substantial damageNTSB 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.Mar 22, 1990 · N92292 · DestroyedNTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.Mar 22, 1990 · N7275G · Substantial damageNTSB 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.Mar 22, 1990 · N5222E · Substantial damageNTSB 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.Mar 21, 1990 · N570RC · No damageNTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.Mar 21, 1990 · N80830 · Substantial damageNTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.Mar 21, 1990 · N3372F · Substantial damageNTSB 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.Mar 21, 1990 · N4373L · Substantial damageNTSB 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.Mar 20, 1990 · N353FG · Substantial damageNTSB 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.Mar 20, 1990 · N4944E · Substantial damageNTSB 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.Mar 20, 1990 · N7379X · Substantial damageNTSB 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.Mar 20, 1990 · N3386L · Substantial damageNTSB MKC90LA073Accident · No injuriesLimited investigationFinal reportBeech B35 · Hartington, NEDirectional control not maintained by the pilot in command.Mar 19, 1990 · N5047C · Substantial damageNTSB LAX90LA129Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Tehachapi, CAA loss of engine power for undetermined reason(s).Mar 19, 1990 · N74245 · DestroyedNTSB LAX90FA123Accident · 1 fatalField investigationFinal reportCessna 172N · Buena Park, CAThe pilot not maintaining the prescribed minimum descent altitude during an instrument approach.Mar 19, 1990 · N2985E · DestroyedNTSB 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.Mar 19, 1990 · N5016F · Substantial damageNTSB 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.Mar 19, 1990 · N5786V · Substantial damageNTSB 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.Mar 18, 1990 · N1220F · DestroyedNTSB NYC90LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Andover, NJThe pilot failed to maintain control of the aircraft after encounter with turbulence during landing.Mar 18, 1990 · N8213L · Substantial damageNTSB 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.Mar 18, 1990 · N3938 · DestroyedNTSB MIA90LA092Accident · Minor injuriesLimited investigationFinal reportTalmadge Scott Longez · St. Petersburg, FLThe failure of maintenance personnel to properly secure the carburetor throttle cable housing.Mar 18, 1990 · N83TS · Substantial damageNTSB 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.Mar 18, 1990 · N554H · Substantial damageNTSB LAX90DUG04Accident · 2 fatalFinal reportWeber Christen Eagle II · Bermuda Dunes, CAThe pilot-in-command's improper use of the flight controls while performing acrobatic maneuvers.Mar 18, 1990 · N234RW · DestroyedNTSB 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.Mar 18, 1990 · N61918 · Substantial damageNTSB ATL90LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, NCThe pilot's delayed pull up from an intentional descent during an aborted suicide attempt.Mar 18, 1990 · N704EA · Substantial damageNTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.Mar 18, 1990 · N5322B · Substantial damageNTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.Mar 17, 1990 · N5336 · Substantial damageNTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.Mar 17, 1990 · N3520R · Substantial damageNTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.Mar 17, 1990 · N17317 · Minor damageNTSB MIA90FA091Accident · 2 fatalField investigationFinal reportWohlers Steen/Skybolt · Quincy, FLInflight loss of control for undetermined reasons.Mar 17, 1990 · N98LW · DestroyedNTSB LAX90LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · Santa Ana, CAThe pilot's improper rotation during takeoff.Mar 17, 1990 · N306AW · Substantial damageNTSB 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.Mar 17, 1990 · N4696L · Substantial damageNTSB CHI90LA099Accident · No injuriesLimited investigationFinal reportPiper PA28R · Chicago, ILFailure of the pilot to maintain control of the accident airplane during an attempted landing.Mar 17, 1990 · N4340K · Substantial damageNTSB 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.Mar 17, 1990 · N6340Z · DestroyedNTSB 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.Mar 17, 1990 · N76026 · Destroyed