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 LAX94LA284Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Tucson, AZa loss of engine power for undetermined reasons.NTSB FTW94FA231Accident · 4 fatalField investigationFinal reportAerospatiale AS-350B1 · Galveston, TXInadequate torquing of the left lateral servo by maintenance personnel, which allowed it to become disconnected from the controls, leading to an in-flight loss of control.NTSB CHI94LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Watersmeet, MIthe pilot's failure to maintain control of the airplane, and his inadequate preflight planning and preparation. Factors associated with the accident were the fog and the trees.NTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB NYC94LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-700P · White Plains, NYThe pilot's delay in aborting the takeoff. A factor was internal obstruction of the pitot tube.NTSB NYC94LA120Accident · No injuriesLimited investigationFinal reportFreeman PRO-STAR II · Sanford, METhe pilot's failure to maintain airspeed resulting in an inadvertent stall and collision with the terrain.NTSB MIA94LA178Accident · 1 fatalLimited investigationFinal reportHickey Windrose · Williston, FLThe pilot-in-command's failure to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact.NTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.NTSB LAX94FA282Accident · 1 fatalField investigationFinal reportCessna 172M · Running Springs, CAthe flying pilot's operation of the aircraft at an altitude that did not provide sufficient terrain clearance necessary to recover from an inadvertent, pilot-induced stall.NTSB FTW94LA230Accident · Serious injuriesLimited investigationFinal reportNorth American Navion 4 · Dupont, LAThe loss of engine power due to inadequate maintenance adjustment of accessory drive starter gear screws which disengaged in flight. Factors were the lack of suitable terrain for the forced landing and non compliance with the applicable service letter.NTSB FTW94GA232Accident · 3 fatalFinal reportBell 206L-3 · Mimbres, NMThe pilot's improper decision to attempt to hover out of ground effect under adverse conditions while exceeding the maximum allowable weight for that maneuver. Factors in the accident were: high density altitude and the tailwind.NTSB ATL94FA137Accident · 2 fatalField investigationFinal reportCessna 150L · Greenville, TNThe failure of the pilot to maintain sufficient terrain clearance, and his inadvertent stall at low altitude.NTSB SEA94LA177Accident · Serious injuriesLimited investigationFinal reportDay Teeny II · Colville, WAThe pilot's failure to maintain altitude sufficient to clear terrain. The downdraft was a factor.NTSB SEA94LA176Accident · No injuriesLimited investigationFinal reportBambrick Corben ACE · Arlington, WAFuel starvation due to the builders' inadequate design of the fuel system. Factors include high ambient temperatures during the climb, and a fence in the field where the forced landing took place.NTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.NTSB NYC94LA116Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Blairstown, NJThe pilot's failure to maintain directional control during takeoff, resulting in a loss of control and collision with the terrain.NTSB NYC94FA119Accident · 1 fatalField investigationFinal reportCessna 172RG · Kiptopeka, VAInadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.NTSB LAX94LA316Accident · No injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe pilot's failure to maintain proper runway alignment by failing to properly compensate for the surface wind conditions. The crosswind and the loose dirt were factors in this accident.NTSB LAX94LA281Accident · Minor injuriesLimited investigationFinal reportSam Hale LONG-EZ · Camarillo, CAfuel starvation due to improper fuel management by the pilot.NTSB LAX94LA280Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Tucson, AZAn engine power loss from fuel exhaustion due to the pilot's inaccurate fuel consumption calculations.NTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.NTSB BFO94WA126Accident · 1 fatalForeign investigationNorth American F-100F · Cuxhaven, GermanyNTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.NTSB ANC94FA080Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Portage Creek, AKThe pilot's inadequate preflight planning and preparation, and his failure to ensure that the airplane was within its gross weight and center-of-gravity limits, which resulted in an inability to obtain sufficient airspeed for sustained flight and a resultant…NTSB NYC94LA118Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Leesburg, VAThe pilot's inadequate incompensation for wind conditions resulting in loss of directional control.NTSB LAX94LA279Accident · Minor injuriesLimited investigationFinal reportFrank M. Kopecky Quickie · Camarillo, CAthe failure or malfunction of the engine ignition system.NTSB FTW94FA226Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Gulf Of MexicoThe pilot's continued flight into known adverse weather. Factors were the thunderstorms and the pilot's disreqard for the forecasted adverse weather.NTSB FTW94FA224Accident · 2 fatalField investigationFinal reportAerospatiale AS 350B-2 · Granite, COFailure of the pilot to assure main rotor clearance from sloping terrain while in a hover. The terrain condition was a related factor.NTSB ATL94LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Chapel Hill, NCThe pilot's failure to attain a proper touchdown point during landing. Factors were the wet, grass runway conditions.NTSB SEA94LA175Accident · Minor injuriesLimited investigationFinal reportPezetel M-18 Dromader · Plymouth, WAThe rudder being jammed in almost the full left position.NTSB SEA94FA174Accident · 3 fatalField investigationFinal reportPiper PA-22-135 · Leavenworth, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.NTSB MIA94LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLThe pilot-in-command's improper approach during a forced landing following partial loss of engine power. The loss of engine power was a factor.NTSB MIA94LA176Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sanford, FLThe failure of the tailrotor driveshaft for undetermined reasons resulting in loss of tailrotor drive. This resulted in the helicopter spinning uncontrolled and descending from a hover until it crashed in the water.NTSB CHI94LA228Accident · No injuriesLimited investigationFinal reportBeech 58 · Oelwein, IAthe pilot's decision to land on a runway with a tailwind. Factors associated with the accident were the tailwind and the wet runway.NTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.NTSB ATL94LA133Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6/B1-H2 · Raeford, NCThe improper inspection of the aircraft by company maintenance personnel, which resulted in an unsafetied and disconnected fuel control arm.NTSB ANC94LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for the wind condition. A factor in the accident was the gusty wind condition.NTSB ANC94LA078Accident · Serious injuriesLimited investigationFinal reportCessna T207 · Kenai, AKThe failure of the engine crankshaft. Factors in the accident were the pilot's inadequate compensation for the wind conditions and not attaining the proper touchdown point at the suitable landing strip.NTSB SEA94LA181Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics PBY-5A · Lincoln City, ORThe pilot's failure to maintain clearance from a boat dock during the aborted takeoff. Factors include the pilot's poor inflight decision to land on a narrow lake under unfavorable wind conditions, and strong crosswinds during the attempted takeoff.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB NYC94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Leesburg, VAThe student pilot's failure to attain adequate airpseed during an aborted landing which resulted in an inadvertent stall and collision with the ground. A factor is the the student pilot's inexperience.NTSB MIA94FA175Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Gulf Of MexicoLoss of engine power due to an undetermined reason. A factor related to the accident was: inadequate passenger briefing by the pilot.NTSB LAX94LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Gilbert Islands (Pacific Ocean)An in flight failure and separation of the tail rotor for undetermined reasons.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB FTW94IA227Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Denver, COFailure of the right main landing gear torque link assembly and shimmy dampener for unknown reasons.NTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.NTSB CHI94LA225Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Grand Rapids, MIthe pilot's improper fuel tank selection resulting in fuel starvation.NTSB CHI94LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Andover, MNthe flight instructor's improper procedures and directives by electing to pull the mixture control to the 'off' position during simulated emergency procedures. A factor associated with the accident is the existence of weather conditions conducive to…NTSB CHI94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Crosby, NDthe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the rough runway, and the pilot's improper preflight planning.