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 LAX94LA284Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Tucson, AZa loss of engine power for undetermined reasons.Jul 13, 1994 · N5668M · Substantial damageNTSB 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.Jul 13, 1994 · N350WM · DestroyedNTSB 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.Jul 13, 1994 · N6579G · DestroyedNTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.Jul 13, 1994 · N1257 · Substantial damageNTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.Jul 12, 1994 · N60426 · Substantial damageNTSB 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.Jul 12, 1994 · N323CB · DestroyedNTSB 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.Jul 12, 1994 · N43579 · Substantial damageNTSB 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.Jul 12, 1994 · N20674 · DestroyedNTSB LAX94LA291Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAthe student's misjudged landing flare and improper bounced landing recovery.Jul 12, 1994 · N5351L · Substantial damageNTSB 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.Jul 12, 1994 · N64193 · DestroyedNTSB 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.Jul 12, 1994 · N8648H · Substantial damageNTSB 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.Jul 12, 1994 · N3178B · DestroyedNTSB ATL94FA137Accident · 2 fatalField investigationFinal reportCessna 150L · Greenville, TNThe failure of the pilot to maintain sufficient terrain clearance, and his inadvertent stall at low altitude.Jul 12, 1994 · N18714 · Substantial damageNTSB SEA94LA177Accident · Serious injuriesLimited investigationFinal reportDay Teeny II · Colville, WAThe pilot's failure to maintain altitude sufficient to clear terrain. The downdraft was a factor.Jul 11, 1994 · N526AD · Substantial damageNTSB 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.Jul 11, 1994 · CFKEZ · Substantial damageNTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.Jul 11, 1994 · N7080B · No damageNTSB 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.Jul 11, 1994 · N2899G · Substantial damageNTSB 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.Jul 11, 1994 · N6624R · 2 aircraft · DestroyedNTSB 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.Jul 11, 1994 · N93839 · Substantial damageNTSB LAX94LA281Accident · Minor injuriesLimited investigationFinal reportSam Hale LONG-EZ · Camarillo, CAfuel starvation due to improper fuel management by the pilot.Jul 11, 1994 · N353H · Substantial damageNTSB LAX94LA280Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Tucson, AZAn engine power loss from fuel exhaustion due to the pilot's inaccurate fuel consumption calculations.Jul 11, 1994 · N3003S · Substantial damageNTSB 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.Jul 11, 1994 · N4367F · Substantial damageNTSB BFO94WA126Accident · 1 fatalForeign investigationNorth American F-100F · Cuxhaven, GermanyJul 11, 1994 · N414FS · DestroyedNTSB 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.Jul 11, 1994 · N3381P · Substantial damageNTSB 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…Jul 11, 1994 · N8297X · Substantial damageNTSB NYC94LA118Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Leesburg, VAThe pilot's inadequate incompensation for wind conditions resulting in loss of directional control.Jul 10, 1994 · N1946X · Substantial damageNTSB LAX94LA279Accident · Minor injuriesLimited investigationFinal reportFrank M. Kopecky Quickie · Camarillo, CAthe failure or malfunction of the engine ignition system.Jul 10, 1994 · N8036W · Substantial damageNTSB 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.Jul 10, 1994 · N55120 · DestroyedNTSB 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.Jul 10, 1994 · N95LG · DestroyedNTSB 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.Jul 10, 1994 · N2452Q · Substantial damageNTSB SEA94LA175Accident · Minor injuriesLimited investigationFinal reportPezetel M-18 Dromader · Plymouth, WAThe rudder being jammed in almost the full left position.Jul 9, 1994 · N4685R · Substantial damageNTSB 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.Jul 9, 1994 · N3645A · DestroyedNTSB 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.Jul 9, 1994 · N5233R · Substantial damageNTSB 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.Jul 9, 1994 · N22431 · Substantial damageNTSB 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.Jul 9, 1994 · N6404Z · Substantial damageNTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.Jul 9, 1994 · N67318 · Substantial damageNTSB 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.Jul 9, 1994 · N111FX · DestroyedNTSB 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.Jul 9, 1994 · N2297R · Substantial damageNTSB 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.Jul 9, 1994 · N91056 · Substantial damageNTSB 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.Jul 8, 1994 · N2172N · Substantial damageNTSB 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.Jul 8, 1994 · N6276M · Substantial damageNTSB 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.Jul 8, 1994 · N63021 · DestroyedNTSB 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.Jul 8, 1994 · N3610W · DestroyedNTSB LAX94LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Gilbert Islands (Pacific Ocean)An in flight failure and separation of the tail rotor for undetermined reasons.Jul 8, 1994 · N9242F · Substantial damageNTSB 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.Jul 8, 1994 · N2936Z · Substantial damageNTSB FTW94IA227Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Denver, COFailure of the right main landing gear torque link assembly and shimmy dampener for unknown reasons.Jul 8, 1994 · N83873 · Minor damageNTSB 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.Jul 8, 1994 · N88XH · DestroyedNTSB CHI94LA225Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Grand Rapids, MIthe pilot's improper fuel tank selection resulting in fuel starvation.Jul 8, 1994 · N153C · Substantial damageNTSB 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…Jul 8, 1994 · N9284U · Substantial damageNTSB 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.Jul 8, 1994 · N9561P · Substantial damage