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 DEN91FA042Accident · 4 fatalField investigationFinal reportCessna U206 · Yampa, COInadvertent accelerated stall by the pilot in command while attempting a turn in close proximity to terrain. A factor was the high altitude.NTSB LAX91LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA22-160 · Bagdad, AZThat the pilot misjudged the landing flare altitude. Contributing to this accident was the failure of the exhaust valve and the pilot's anxiety during the emergency.NTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.NTSB CHI91DEM03Accident · No injuriesFinal reportHuddleston/Becktold Glasair · Lansing, MIFailure of the instructor pilot (CFI) to maintain sufficient airspeed on final approach to flare the aircraft for landing. Factors related to the accident were: the landing gear malfunction, and the cfi's improperly planned approach.NTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.NTSB LAX91LA123Accident · No injuriesLimited investigationFinal reportBeech B95 · Riverside, CAFailure of the pilot to follow the emergency gear extension procedure to fully extend the landing gear. Contributing to the accident was the failure of the pilot to monitor the condition of the electrical power system, leading to the complete loss of…NTSB LAX91LA097Accident · No injuriesLimited investigationFinal reportRobinson R22A · Piru, CAFailure of the CFI to maintain main rotor RPM during a demonstrated autorotation.NTSB DEN91LA041Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Durango, COEngine failure due to oil starvation caused by turbocharger oil feed line failure and subsequent loss of lubricating oil to the engine.NTSB CHI91LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Osseo, WIFuel exhaustion which occurred when the pilot became lost/disoriented. Factors related to the accident were: the pilot's lack of total experience, the terrain condition, and a fence.NTSB CHI91LA095Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Teedsburg, WIFailure of the pilot to obtain or maintain adequate airspeed for a go-around (aborted landing), which resulted in an inadvertent stall/mush. The failure to attain proper runway alignment for landing was a related factor.NTSB ATL91LA061Accident · Serious injuriesLimited investigationFinal reportMaxair ARV 582 · Eastman, GAThe inadvertent stall of the aircraft which was encountered as a result of the lack of total experience of the non-rated pilot.NTSB ATL91LA053Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Grantham, NCThe pilot's improper planning/decision, and his attempt to fly the aircraft while it was loaded over its maximum allowable gross weight.NTSB ANC91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kivalina, AKThe pilot's failure in not identifying the weather conditions along the route. Contributing to the accident was improper in flight planning and decision by the PIC and the whiteout conditions.NTSB ANC91LA026Accident · Minor injuriesLimited investigationFinal reportMBB BO-105-CBS-4 · Valdez, AKWas the pilot-in-command's failure to properly use the approval checklist, improper procedures and directives.NTSB LAX91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAThe failure of the no. 5 cylinder due to fatigue. Contributing to this accident was the wet terrain and crops.NTSB LAX91FA094Accident · 2 fatalField investigationFinal reportBoeing N2S-3 · Sonoma, CAThe pilot-in-command/cfi's performance of a low altitude aerobatic maneuver from which he failed to recover. Factors which contributed to the accident related to the pic's improper inflight decision, poor judgment, and his psychological condition.NTSB LAX91FA093Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's inadvertent flight into IMC and his failure to maintain aircraft control of the airplane. Factors which contributed to the accident related to the pilot becoming disoriented in the dark, nighttime, instrument weather conditions, and to the pilot's…NTSB FTW91DPA01Accident · Serious injuriesFinal reportDonald E. Samuels Q2 · Gilmer, TXThe pilot's failure to attain proper climb performance.NTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.NTSB CHI91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrence, KSFailure of the student pilot to maintain directional control of the aircraft, which resulted in a ground swerve.NTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.NTSB MIA91LA080Accident · No injuriesLimited investigationFinal reportBeech 58 · St. ThomasExcessive descent rate by the pilot, improper recovery from the bounced landing, and failure to recover from the porpoise condition.NTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.NTSB SEA91LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Helena, MTThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was the pilot's improper flare on landing inadequate recovery from a bounced landing, and the pilot's lack of total and recent experience.NTSB NYC91FA073Accident · 2 fatalField investigationFinal reportBeech BE-58 · Skaneateles, NYThe pilot's loss of situational awareness/disorientation due to the influences of cocaine, which resulted in the loss of airplane control in instrument meteorological conditions. Factors related to the accident were: psychological impairment, fatigue and…NTSB MIA91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150G · La Belle, FLTotal loss of engine power due to undetermined reasons.NTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.NTSB ATL91FA052Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Munford, ALThe pilot attempting visual flight in instrument meteorological conditions below the minimum safe altitude for terrain clearance. Contributing factors were the low ceiling and mountainous terrain.NTSB ATL91FA051Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Liberty, NCFailure of the pilot to maintain a positive rate-of-climb after lift-off. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's limited experience in a Piper PA-23.NTSB ANC91LA025Accident · No injuriesLimited investigationFinal reportCessna 172-P · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the terrain (snowbank).NTSB SEA91LA048Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Draper, UTAn undetermined loss of engine power.NTSB LAX91LA092Accident · No injuriesLimited investigationFinal reportCessna 150M · Buckeye, AZThat maintenance personnel failed to properly install the wings by not reconnecting the bolts at the bellcrank and performed an inadequate annual inspection.NTSB CHI91FA091Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Dutchtown, MOThe pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.NTSB LAX91LA091Accident · No injuriesLimited investigationFinal reportCessna 340 · Columbia, CAAn unavoidable collision with animals (deer) on landing roll. Contributing to the accident was the airport environment that cannot preclude deer from gaining access to the airport.NTSB CHI91FA090Accident · 1 fatalField investigationFinal reportBeech F.35 · Sidney, OHThe pilot's intentional VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's disregard for directives and overconfidence in his ability.NTSB ATL91IA050Incident · No injuriesIncident investigationFinal reportPiper PA-60-600 · Cochran, GAFailure of the right engine shutoff valve which resulted in a complete loss of engine power. The airplane veered off the right side of the runway and the right main landing gear collapsed as a result of the pilots failure to maintain directional control…NTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.NTSB NYC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper J-3-C · Hamilton, OHThe failure of the pilot-in-command to touchdown in a suitable area after he experienced a power loss. A factor related to the accident was the improperly maintained carburetor.NTSB ATL91FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Greensboro, NCAn encounter with wake turbulence which resulted in an uncontrolled descent. An additional cause was pilot's physiological conditions and his use of medication.NTSB ANC91LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Talkeetna, AKWas the pilot-in-command's improper in-flight planning and decision. Contributing to the accident was the pilot's failure to refuel the airplane prior to the cross-country flight.NTSB SEA91FA046Accident · 2 fatalField investigationFinal reportCessna C-172 · Colstrip, MTThe pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…NTSB MIA91WA079Accident · No injuriesForeign investigationBeech B36TC · Pitts Town, BahamasNTSB MIA91LA077Accident · No injuriesLimited investigationFinal reportRyan Navion · Lake City, FLIn-flight encounter with wind shear while on short final resulting in a hard landing.NTSB LAX91LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Pixley, CAThe failure of the pilot to use carburetor heat in carburetor icing conditions. Contributing to the accident was the lack of experience in the accident airplane make and model.NTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.NTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.NTSB DEN91LA027Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Durango, COThe pilot's failure to maintain directional control of the airplane. Contributing factors were the pilot's lack of experience in airplane type and crosswind conditions.NTSB CHI91LA089Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Browning, MOFuel starvation due to a blocked fuel vent. A factor related to the accident was unsuitable terrain.NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.NTSB CHI91DEX02Accident · No injuriesFinal reportHagg Starduster TOO · Shelbyville, INThe pilot's inadequate preflight planning/preparation, not refueling the aircraft before taking off on this flight, and inaccurate fuel consumption calculations. A factor related to the accident is the unsuitable terrain selected by the pilot for a forced…