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 SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.NTSB LAX91LA073Accident · No injuriesLimited investigationFinal reportBeech D-35 · Bullhead City, AZLoss of directional control on the ground.NTSB CHI91LA072Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Springbrook, WIThe pilot's attempt to takeoff with a strong gusty tailwind.NTSB CHI91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marshall, ILFlight into known adverse weather by the pilot(s) and subsequent icing of the Piper PA-32'S air induction system. Factors related to the accident were: the adverse weather conditions and a perceived sense of urgency to make the flight.NTSB CHI91LA066Accident · No injuriesLimited investigationFinal reportCessna 140 · So. Sioux City, NEDirectional control not maintained by the pilot-in-command. Factors related to the accident were a snow covered runway and a lack of recent experience.NTSB SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.NTSB MIA91WA065Accident · No injuriesForeign investigationPiper PA-23-250 · Little Whale, BahamasNTSB LAX91DUQ01Accident · No injuriesFinal reportVirgil D. Hawks Quickie · Camarillo, CAThe pilot's encounter with wake turbulence and his inflight loss of control by his failure to maintain a sufficient landing distance from a larger aircraft preceding his aircraft.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.NTSB CHI91LA068Accident · No injuriesLimited investigationFinal reportCessna 182A · Chadron, NEAn engine power loss for undetermined reasons.NTSB CHI91LA067Accident · No injuriesLimited investigationFinal reportBeech 200 · Vichy, MOA restricted visual outlook and go-around was not performed by the pilot. Factors related to the accident were a dark night, fog and glare, ice covered runway and whiteout conditions.NTSB MIA91LA064Accident · No injuriesLimited investigationFinal reportCessna 175 · Okeechobee, FLFailure of the right brake line at the caliper during the landing roll rendering the brakes ineffective. A factor was the pilot's misjudgement of wind direction.NTSB LAX91LA072Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Torrance, CAThe pilot's improper use of the rotorcraft's flight controls. Contributing factors were related to the pilot's lack of experience in the type of low altitude maneuver.NTSB FTW91FA029Accident · Serious injuriesField investigationFinal reportBeech F-90 · Nacogdoches, TXThe loss of thrust due to the propeller's feathering on liftoff as a result of improper adjustments made during an engine change. A factor was the lack of suitable terrain to which the pilot could execute a forced landing.NTSB CHI91LA065Accident · No injuriesLimited investigationFinal reportCessna 152 II · St. Cloud, MNThe student pilot's failure to maintain directional control during acceleration for takeoff.NTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).NTSB LAX91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ramona, CAThe pilot's failure to maintain directional control of the airplane during an attempted takeoff. A contributing factor was related to the student's improper use of rudder control.NTSB FTW91FA028Accident · 2 fatalField investigationFinal reportFolland Gnat T-1 · Bossier City, LAImproper planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to lack of fuel. The adverse weather conditions and radio malfunction were related factors.NTSB CHI91LA064Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Elkhart, INA fractured landing gear retraction assembly component and the pilot's improper emergency procedure.NTSB MIA91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 182N · La Belle, FLThe pilot's failure to maintain altitude. A factor was the pilot's failure to obtain a weather forecast.NTSB LAX91LA070Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZThe instructor pilot's delay in executing a recovery flare from the autorotative descent, and the helicopter's inadequate altitude during flare. A contributing factor was related to the instructor pilot being inattentive to his student's performance.NTSB CHI91IA062Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Kansas City, MOImproper use of the throttles, and failure to maintain directional control by the first officer. Factors related to the incident are: ice on the runway, lack of total experience in the type aircraft and operation by the first officer, and inadequate…NTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NTNTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.NTSB ATL91FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172D · Missing (Atlantic Ocean)The pilot's continuation of visual flight into instrument meteorological conditions which resulted in spatial disorientation and a loss of aircraft control. Factors related to the accident were: the pilot's failure to obtain a weather briefing before…NTSB NYC91FA058Accident · 1 fatalField investigationFinal reportMooney M20K · Gallipolis, OHThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertant stall at too low an altitude to allow recovery. A factor relating to the accident was the pilot's trepidation about a successful landing because of the weather.NTSB LAX91LA069Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hilo, HIThe failure of the pilot to maintain an adequate airspeed while maneuvering. A factor in the accident was the pilot's decision to attempt steep and abrupt maneuvers during the takeoff initial climb phase.NTSB LAX91LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Ukiah, CAThe failure of the pilot to maintain an adequate clearance from ground obstructions. A factor in the accident was: failure of the pilot to maintain an altitude sufficient to clear all obstructions along his route of flight.NTSB LAX91FA066Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAThe failure of the pilot-in-command to maintain control of the airplane while flying in instrument meteorological conditions and spatial disorientation of the pilot-in-command. Contributing to the accident was diversion of the pilot's attention to…NTSB FTW91FA027Accident · 6 fatalField investigationFinal reportCessna 421B · Muskogee, OKThe pilot's failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: darkness, adverse weather conditions, and the pilot's physical impairment from the chronic sinus infection.NTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.NTSB CHI91FA059Accident · 1 fatalField investigationFinal reportCessna 172P · Freeport, ILThe pilot-in-command's failure to maintain airspeed. Factors contributing were the pilot-in-command's misuse of flaps and his lack of total experience in this type of operation.NTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.NTSB DEN91LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Deming, NMPilot failure to maintain airspeed during takeoff climb resulting in a stall and subsequent loss of control of the aircraft. A factor was: the failure of the CFI to adequately supervise the student pilot.NTSB ANC91FA019Accident · No injuriesField investigationFinal reportCessna 172G · Wasilla, AKPilot's not removing the frost from the airplane before attempting to takeoff. Contributing to the accident was the pilot's delayed abort, and the berm.NTSB NYC91LA057Accident · Serious injuriesLimited investigationFinal reportBeech U35B · Columbia, OHThe pilot mismanaged his fuel and ran one of the fuel tanks dry, resulting in an engine failure, due to fuel starvation.NTSB CHI91LA063Accident · No injuriesLimited investigationFinal reportCessna 150L · Bemidji, MNThe pilot's improper preflight inspection of the airplane.NTSB CHI91IA058Incident · Minor injuriesIncident investigationFinal reportBoeing B727-223 · Des Moines, IAAn oil leak originating from the auxiliary power unit which created smoke in the passenger cabin after it passed through the air conditioning/heating system equipment and associated duct work.NTSB SEA91FA039Accident · 1 fatalField investigationFinal reportCessna 140 · Port Orchard, WAThe pilot's failure to initiate an aborted takeoff at a time that left adequate runway remaining to bring the aircraft to a stop.NTSB LAX91FA065Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glendale, CAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his improper inflight decision to turn to the left, which resulted in flight toward higher terrain. The terrain and weather conditions were related factors.NTSB CHI91LA056Accident · No injuriesLimited investigationFinal reportCessna 340 · Chesterfield, MOFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident are a foggy windshield, misjudgement of altitude, premature landing flare, and slush on the runway.NTSB NYC91FA055Accident · 1 fatalField investigationFinal reportCessna 172P · Rattlesnake Isl, OHThe cfi's delayed decision to execute a go-around from a long landing and subsequent failure to obtain/maintain flying speed.NTSB MIA91LA060Accident · No injuriesLimited investigationFinal reportHughes 269C · Deland, FLFailure of the commercial pilot applicant to pull collective pitch and delay by the check airman to pull collective and apply power to recover, resulting in a hard landing.NTSB CHI91LA055Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Jerseyville, ILLoss of engine power for undetermined reasons and the icy runway conditions.NTSB ATL91LA036Accident · No injuriesLimited investigationFinal reportCessna 195B · La Grange, GAThe failure of the tailwheel steering spring.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.NTSB LAX91LA064Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Truckee, CA1) The pilots improper flare maneuver; 2) his failure to perform a bounced landing recovery; and 3) his failure to maintain directional control of the aircraft.NTSB DEN91LA030Accident · No injuriesLimited investigationFinal reportCessna 206A · Carlsbad, NMA loss of control by the pilot during landing roll due to his failure to maintain directional control.