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 BFO92FA069Accident · 2 fatalField investigationFinal reportCessna 172P · Princeton, NJThe pilot's failure to maintain clearance over an obstacle. Contributing factors were a tailwind, dark night, and premature raising of the flaps.NTSB LAX92TL#06Accident · No injuriesClass 3Final reportMitsubishi MU2B-36 · Edwards Afb, CANTSB DEN92LA053Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COThe pilot did not maintain clearance and the airplane collided with a fence post.NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.NTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.NTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.NTSB MIA92LA124Accident · No injuriesLimited investigationFinal reportCessna 172-P · Daytona Beach, FLThe delayed remedial action by the pilot-in-command (CFI) to the student's pushing the control yoke forward on short final approach.NTSB MIA92LA123Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Fort Lauderdale, FLDelay by the CFI to take remedial action. Contributing to the accident was the students premature flare.NTSB BFO92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Carollton, OHThe pilot's inadequate starting procedure.NTSB BFO92LA067Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Vine Grove, KYThe pilot's failure to maintain directional control. Contributing factors were wind gusts and the pilot's inadequate compensation for wind.NTSB BFO92LA065Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Sabina, OHThe pilot's inadequate compensation for wind which resulted in a loss of directional control. Contributing to the accident was wind gusts.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.NTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.NTSB CHI92LA150Accident · No injuriesLimited investigationFinal reportBeech C23 · Saginaw, MIThe first pilot's improper recovery from a bounced landing. A factor in the accident was the first pilot's lack of experience in the aircraft type.NTSB BFO92LA066Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe pilot's improper IFR operation. Contributing was the pilot's lack of recent instrument flight time.NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.NTSB FTW92LA142Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Palacios, TXThe flight's unexpected encounter with moderate turbulence.NTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.NTSB FTW92LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · Stilwell, OKThe pilot inadvertently pushed the nose down during the flare/landing. A factor was the pilot misjudged the flare/landing.NTSB CHI92LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Springfield, MOFailure of the pilot in command to maintain control of the airplane during a downwind landing.NTSB ATL92FA102Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Greenville, NCFailure of the pilot to maintain a proper climb rate after takeoff after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, the pilot's self-induced pressure to make the flight, and his lack of total…NTSB SEA92LA104Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B-2B · Hood River, ORThe delayed remedial action of the pilot (CFI). Factors include lack of total experience in type of aircraft, and lack of total experience in type of operation.NTSB SEA92LA099Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Kalispell, MTThe pilot's failure to maintain adequate airspeed during the go-around.NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.NTSB FTW92LA134Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Mooreland, OKThe failure of the number 3 cylinder for undetermined reasons. A factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.NTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.NTSB BFO92LA062Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Middleboro, MAThe pilot's failure to release a tie down strap from the helicopter's skid during the preflight.NTSB BFO92LA061Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-1S · Hopkinsville, KYThe failure of the number 2 oil ring in the number 4 engine cylinder resulting in oil leakage, loss of oil pressure, and engine power loss.NTSB ANC92LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Old Minto, AKThe pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.NTSB NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.NTSB LAX92IA209Incident · Minor injuriesIncident investigationFinal reportBoeing 767-222 · Los Angeles, CAA rupture in the airplane's air condition/heat/pressurization/apu duct, along its welded seam. Contributing to the incident was the manufacturers' failure to issue a service bulletin applicalbe to all APU ducts in the systems.NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.NTSB CHI92LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSThe student pilot's improper recovery from a bounced landing, and the instructor's inadequate remedial action(s).NTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.NTSB LAX92T#A05Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · San Diego, CANTSB FTW92LA130Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARThe loss of complete engine for undetermined reasons. A factor was the low altitude and unsuitable terrain.NTSB DEN92LA051Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COLoss of directional control during landing roll by the pilot under instruction. A factor was: inadequate supervision by the certified flight instructor.NTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.NTSB BFO92LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Easton, PAThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB ANC92LA073Accident · No injuriesLimited investigationFinal reportCessna C-150K · Beluga, AKThe improper inflt decision by the pilot to land on a remote, private, snow covered airstrip. A factor relating to the accident was the soft, wet snow on the strip.NTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.NTSB FTW92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terrell, TXThe pilot's alcoholic impairment of efficiency and judgement which led to his inattention to the amount of fuel remaining in the left fuel tank, resulting in fuel starvation and a total loss of engine power. A factor in the accident was the existence of the…NTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.NTSB BFO92LA057Accident · Serious injuriesLimited investigationFinal reportCessna 210M · West Mifflin, PAThe pilot's inadequate preflight preparation. Contributing to the accident was the unreliable fuel quantity gauges.