NTSB investigations, 1994
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 1994 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 WHERE year(c."eventDate") = 1994 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 DCA95RA009Accident · 5 fatalForeign investigationBoeing B737-2D6C · Coventry, AlgeriaNTSB CHI95LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Allegan, MIthe student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.NTSB NYC95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gr. Barrington, MAThe pilot landed with excessive airspeed which resulted in a long landing, runway overrun, and collision with trees.NTSB MIA95WA045Accident · No injuriesForeign investigationMooney M20J · Spanish Cay, BahamasNTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.NTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.NTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.NTSB LAX95LA054Accident · No injuriesLimited investigationFinal reportCessna 120 · Torrance, CAA blockage in the carburetor heat air duct which limited the effectiveness of the system's ability to prevent the formation of carburetor ice and resulted in a loss of power. A factor in the accident was the soft nature of the recently plowed ground in the…NTSB LAX95FA053Accident · 2 fatalField investigationFinal reportNorth American NAVION-A · Big Bear City, CAthe pilot's initial overrotation, his failure to attain the proper climb airspeed, and an inadvertent entry into a stall mush condition. A factor in the accident was the high-density altitude.NTSB NYC95IA043Incident · No injuriesIncident investigationFinal reportBoeing 747-131 · Jamaica, NYImproper maintenance overhaul which resulted in a fatigue crack.NTSB MIA95LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe student pilots failure to follow the checklist and assure the door was closed prior to takeoff. Contributing to the accident was the student's diverted attention during the takeoff roll.NTSB FTW95LA068Accident · No injuriesLimited investigationFinal reportCessna A150L · Newark, TXThe loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.NTSB FTW95FA069Accident · 1 fatalField investigationFinal reportPiper PA-32RT · San Antonio, TXThe loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.NTSB ATL95LA029Accident · No injuriesLimited investigationFinal reportCessna 172F · Carrollton, GAThe pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.NTSB SEA95LA030Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Heber City, UTAn open connection clip. A factor to the accident was a locked tail wheel assembly.NTSB FTW95LA067Accident · Serious injuriesLimited investigationFinal reportTimothy J Brown Pitts S2SE · Grand Prairie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.NTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.NTSB FTW95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Eagle Nest, NMThe pilot's flight into rising terrain without sufficient altitude and climb performance available to clear the trees and terrain. A factor was the pilot becoming lost and disoriented.NTSB CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.NTSB SEA95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, WAThe pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.NTSB NYC95WA235Accident · 2 fatalForeign investigationDouglas DC-3C · Lobito, Central African RepublicNTSB MIA95LA040Accident · No injuriesLimited investigationFinal reportCessna 208B · Memphis, TNThe inability of the pilot of Cessna 208, N927FE to see Douglas DC3, N24320, as he taxied to takeoff due to inoperative tail navigation lights and beacon lights on the DC3 and due to glare on the wet taxiway.NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.NTSB LAX95LA051Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Oasis, CAthe pilot's improper inflight decision by selecting an inadequate terrain clearance altitude over mountainous terrain.NTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.NTSB LAX95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe overload failure of the nose gear trunion for undetermined reasons.NTSB DCA95MA007Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Fresno, CA1) Improperly installed electrical wiring for special mission operations that led to an in-flight fire that caused airplane systems and structural damage and subsequent airplane control difficulties; 2) improper maintenance and inspection procedures followed…NTSB BFO95LA021Accident · Minor injuriesLimited investigationFinal reportElvin N. Kier Varieze · Cleveland, OHA fatigue crack in the right elevator torque tube resulting in the disconnection of the elevator torque tubes and subsequent loss of airplane control.NTSB ATL95LA028Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Hickory, NCThe pilot's failure to attain a proper touchdown point during the transition to landing, which resulted in a long landing and overrun. Factors were the low ceilings and fog which prevailed at the time of the accident.NTSB DCA95MA006Accident · 15 fatalMajor investigationFinal reportBritish Aerospace Jetstream 3201 · Morrisville, NC1) the captain's improper assumption that an engine had failed, and 2) the captain's subsequent failure to follow approved procedures for engine failure, single-engine approach and go-around, and stall recovery. Contributing to the cause of the accident was…NTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…NTSB ANC95LA020Accident · No injuriesLimited investigationFinal reportCessna 207 · Saint Mary'S, AKThe pilot's decision to continue visual flight into instrument meteorological conditions. Factors associated with the accident are the pilot's failure to maintain adequate altitude/clearance from terrain, and the whiteout weather conditions.NTSB MIA95LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe failure of the pilot-in-command to insure the aircraft contained enough fuel to complete the flight resulting in engine failure due to fuel exhaustion.NTSB MIA95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLThe pilot-in-command became lost and operated the aircraft until fuel exhaustion.NTSB FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.NTSB FTW95IA064Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Dfw Airport, TXFire due to the internal failure of the number one DC starter-generator.NTSB ANC95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged landing flare.NTSB ANC95LA017Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Takotna, AKThe pilot's inadequate preflight planning for the departure. A snow covered runway, flat lighting conditions, and a snowbank were factors in the accident.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…NTSB LAX95LA050Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Tehachapi, CAthe pilot's poor in-flight planning/decision and inadequate airspeed. The downdraft and trees were factors in this accident.NTSB LAX95LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Corona, CAthe pilot's failure to maintain directional control due to his improper use of the rudder and brakes.NTSB LAX95LA048Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Cabazon, CAAn unknown event (presumably a component/system failure) that resulted in loss of drive train power to the main rotor system. Factors related to the accident were: darkness and the obstruction (transmission line) in the emergency landing area.NTSB FTW95LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKThe pilot's improper recovery from a bounced landing. Factors were the improper flare and the resultant loss of directional control.NTSB CHI95LA057Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Scott City, KSthe pilot's failure to attain compensation for wind conditions. A factor was the crosswind condition.NTSB ATL95LA027Accident · Minor injuriesLimited investigationFinal reportAero Commander 500S · Millington, TNThe pilot's inadequate preflight of the aircraft, in that he did not ensure that there was adequate fuel for the flight, which resulted in fuel exhaustion.NTSB ATL95LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe pilot's failure to maintain directional control during a crosswind takeoff.NTSB ANC95FA019Accident · Serious injuriesField investigationFinal reportBoeing 737-3M8 (300) · Anchorage, AKThe failure of the b system channel autopilot elevator actuator.NTSB SEA95LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Medicine Bow, WYThe failure of the magneto system due to shorting of both magneto coils to the magneto housing and the lack of suitable terrain to make a forced landing.