NTSB investigations, 1996
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1996 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") = 1996 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 FTW97FA033Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-36 · Boulder, COThe pilot exceeding the design stress limits of the aircraft by performing an aerobatic maneuver, resulting in total failure of the wing spar.NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.NTSB CHI97LA018Accident · 1 fatalLimited investigationFinal reportFrost RAF 2000 GTX SE · Adrian, MIthe pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.NTSB MIA97WA018Accident · 14 fatalForeign investigationEmbraer EMB-110 · Flores, GuatemalaNTSB LAX97LA035Accident · Minor injuriesLimited investigationFinal reportAerostar YAK 52 · Fullerton, CAloss of engine power due to an undetermined internal carburetor malfunction. A factor relating to the accident was: the directions that were use for reassembly of the aircraft were written only in Russian.NTSB LAX97LA030Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZimproper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.NTSB FTW97LA041Accident · No injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKThe failure of the main landing gear pivot gear assembly.NTSB FTW97FA032Accident · 1 fatalField investigationFinal reportMooney M20J · San Leon, TXThe pilot's inadvertent stall and spin of the airplane. Factors were the pilot's lack of total experience in the make and model of airplane and the weather conditions.NTSB ATL97LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brooksville, FLThe loss of engine power for undetermined reasons.NTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNNTSB MIA97IA016Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Mccomb, MSthe lineman's fueling of the aircraft with the wrong type fuel, the pilot's failure to verify the type of fuel added to the aircraft before flight, and failure of the refueling facility to be equipped with the proper fuel nozzle.NTSB LAX97LA029Accident · No injuriesLimited investigationFinal reportCessna 310H · Show Low, AZwater/ice contamination in the fuel system and/or fuel filters due to failure of the maintenance facility that performed the annual inspection to identify and replace four cracked and deteriorated fuel filler cap O-rings. A factor in this accident was the…NTSB FTW97LA030Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Creole, LAthe pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.NTSB DCA97WA004Accident · 97 fatalForeign investigationFokker 100 · Sao Paulo, BrazilNTSB ATL97LA016Accident · No injuriesLimited investigationFinal reportCessna 188B · Ocilla, GAThe pilot's failure to adequately preflight and plan the fuel required for the flight.NTSB ATL97LA012Accident · Serious injuriesLimited investigationFinal reportDouglas C-47 · Dorado, PRfailure of the #11 cylinder on the right (#2) engine, which resulted in an in-flight fire and loss of power in that engine; and a malfunction/failure of the #2 feathering system, which led to a subsequent forced landing before the flight crew could return to…NTSB ATL97LA011Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Abbeyville, ALThe loss of engine power for undetermined reasons.NTSB ATL97FA014Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Avon Park, FLThe pilot's improper use of the elevator trim, which resulted in runway contact by the propeller during the takeoff roll and subsequent loss of aircraft control.NTSB LAX97LA028Accident · Serious injuriesLimited investigationFinal reportLeibert BD-5B · Phoenix, AZloss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.NTSB IAD97FA014Accident · 2 fatalField investigationFinal reportCessna 172L · Brandy Station, VAthe certificated flight instructor's failure to ensure that proper altitude/clearance was maintained above the terrain and trees, while on final approach. Darkness was a related factor.NTSB FTW97LA031Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mckinney, TXthe pilot's inadequate preflight planning/preparation, by selecting a seat/cushion that would not allow adequate knee clearance and ankle movement in the cockpit, which was subsequently attributed to the pilot's failure to maintain directional control during…NTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…NTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.NTSB SEA97TA023Accident · 1 fatalFinal reportBell 47G-3B-1 · Fillmore, UTinadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…NTSB SEA97LA022Accident · 1 fatalLimited investigationFinal reportCollier Q200 · Estacada, ORinadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…NTSB NYC97LA009Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Jamaica, NYFailure of the nose landing gear upper lock link.NTSB ANC97LA005Accident · No injuriesLimited investigationFinal reportKen Seright Rotorway Exec 162F · Haines, AKa leaking coolant hose that saturated the induction air filter and one electronic ignition system with coolant. Unsuitable terrain for a forced landing was a related factor in the accident.NTSB LAX97FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Indio Hills, CAthe pilot's spatial disorientation which led to a loss of aircraft control, and exceeding the aircraft's structural design limits after the aircraft had entered a descending spiral. The pilot's lack of instrument flight currency and the dark night were…NTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.NTSB NYC97FA011Accident · 2 fatalField investigationFinal reportYakovlev YAK-18T · Berlin, NJan inadequate preflight by unknown person(s), sometime before the flight, by failing to avoid a hydraulic lock (from oil seepage) in the #5 cylinder, which resulted in a bent connecting rod, subsequent failure of the #5 piston, and loss of engine power. Also…NTSB MIA97FA014Accident · 1 fatalField investigationFinal reportBellanca 14-13-2 · Smithville, TNloss of engine power for undetermined reason(s), shortly after takeoff; and failure of the pilot to maintain adequate airspeed, while turning in an attempt to maneuver back to the airport, which resulted in an inadvertent stall and uncontrolled descent into…NTSB LAX97LA026Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · San Diego, CAloss of engine power on final approach for undetermined reason(s).NTSB ATL97LA010Accident · 2 fatalLimited investigationFinal reportLindberg Kitfox IV · Merritt Island, FLA loss of engine power for undetermined reasons and the failure of the pilots to maintain airspeed.NTSB NYC97LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Hilton, NYthe pilot's improper soft field landing technique, which allowed a nose over during the landing rollout. Soft terrain was a related factor.NTSB MIA97FA013Accident · 3 fatalField investigationFinal reportCessna 172P · St. Croixthe pilot's failure to maintain airspeed.NTSB LAX97LA025Accident · No injuriesLimited investigationFinal reportLuscombe 8A · El Cajon, CAunfavorable weather condition(s), which caused the aircraft to descend at a rate that exceeded its climb capability.NTSB IAD97LA013Accident · No injuriesLimited investigationFinal reportCessna 140 · Wakefield, VAuncommanded operation of the parking brake, due to a missing tension spring, which resulted in locked brakes and subsequent nose over of the airplane during landing.NTSB FTW97LA027Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Lubbock, TXthe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB ANC97LA006Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Kasilof, AKthe pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…NTSB SEA97LA021Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Laramie, WYVFR flight by the pilot into instrument meteorological conditions (IMC), his misjudged speed/distance on final approach for landing, and his failure to attain the proper touchdown point during the landing. Factors relating to the accident include snow, low…NTSB SEA97LA020Accident · Minor injuriesLimited investigationFinal reportKarmy Rotorway Exec · Redmond, ORThe pilot's failure to remove the dolly wheels during the preflight inspection.NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB MIA97LA042Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F206C · Kissimmee, FLthe pilot misjudged the flare resulting in a hard landing.NTSB IAD97LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Sheffield, MAThe pilot's abrupt control of the airplane, which resulted in an inadvertent stall, uncontrolled descent, and subsequent in-flight collision with water.NTSB CHI97LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jenison, MIthe pilot's inadequate compensation for the wind conditions. A factor was the crosswind condition.NTSB ATL97LA009Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Amelia Island, FLinadequate maintenance/inspection, which resulted in a failure to detect and correct moisture contamination of the left magneto; and/or improper adjustment of the engine fuel pump output, which resulted in excessive fuel pressure.NTSB ATL97LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GApremature flare by the dual student, and his improper remedial action to correct the flare; and inadequate supervision by the flight instructor (CFI).NTSB FTW97LA028Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Giddings, TXThe loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.NTSB FTW97LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28C-180 · Sterling, COimproper starting procedure used by the airport employee. Factors relating to the accident were: the inoperative starter, and failure of the pilot to seek proper assistance.NTSB FTW97LA025Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Jefferson, TXThe pilot's failure to attain the proper touchdown point, and his failure to maintain clearance from the fence. A factor was the fence post.