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 LAX97LA034Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Flagstaff, AZAn uncommanded main rotor blade to tail boom contact due to a 'blowback' phenomena after a successful preplanned autorotation by the pilot to a high density altitude airport with a test aircraft designed at a maximum gross weight.NTSB IAD97LA015Accident · No injuriesLimited investigationFinal reportAyres Scorpion Executive · Union Vale, NYthe pilot's failure to maintain control of the helicopter, which resulted in a subsequent emergency landing and collision with a fence and a cherry picker (vehicle). A factor relating to the accident was: the student pilot's lack of experience in the type…NTSB SEA97LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Price, UTThe pilot's failure to maintain directional control during the landing roll.NTSB FTW97LA035Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tyler, TXa loss of engine power due to failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA022Accident · Serious injuriesLimited investigationFinal reportGalaxy AX8 · Columbia, MOthe pilot's selection of unsuitable terrain for landing. Factors relating to the accident were: the ditch, which was encountered during the landing; and high vegetation, which covered the ditch making it not visible to the pilot.NTSB CHI97LA021Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Kirksville, MOan improper maintenance overhaul by company maintenance personnel which led to a bearing failure. The soft terrain was a factor.NTSB CHI97LA019Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-235 · Hubbard Lake, MIthe pilot's inadequate compensation for wind conditions, and failure to maintain proper alignment with the airstreip during the go-around (aborted landing). The crosswind and proximity of trees were related factors.NTSB NYC97LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Norwood, MAfailure of the pilot to perform a go-around, when an animal obstructed the runway; and his failure to maintain clearance from an obstruction (VASI). Factors relating to the accident were: darkness, an animal (deer) on the runway, and the proximity of the…NTSB LAX97LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Lake Havasu, AZcarburetor ice, and failure of the pilot to use carburetor heat, which resulted in loss of engine power. Factors relating to the accident were: carburetor icing conditions, darkness, and the lack of suitable terrain for a forced landing.NTSB LAX97LA031Accident · 2 fatalLimited investigationFinal reportRainey Rans S-12 · Tucson, AZa broken wire in the ignition coil, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spin and uncontrolled collision with the terrain.NTSB LAX97FA032Accident · 5 fatalField investigationFinal reportPiper PA-34-200 · Halawa, HIthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain sufficient clearance and/or altitude from mountainous terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB FTW97LA034Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Mancos, COfailure of the pilot to maintain clearance from the windsock, during a hover/pedal-turn after lift-off.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.