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.

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.Feb 12, 1991 · N8014Z · DestroyedNTSB 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.Feb 11, 1991 · N3064Z · Substantial damageNTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.Feb 11, 1991 · N2486Q · DestroyedNTSB 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.Feb 11, 1991 · N270KT · Substantial damageNTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.Feb 10, 1991 · N9796V · Substantial damageNTSB 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…Feb 10, 1991 · N2712Y · Substantial damageNTSB LAX91LA097Accident · No injuriesLimited investigationFinal reportRobinson R22A · Piru, CAFailure of the CFI to maintain main rotor RPM during a demonstrated autorotation.Feb 10, 1991 · N8491A · Substantial damageNTSB 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.Feb 10, 1991 · N9653Y · Substantial damageNTSB 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.Feb 10, 1991 · N49288 · Substantial damageNTSB 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.Feb 10, 1991 · N4596D · Substantial damageNTSB 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.Feb 10, 1991 · UNREG · Substantial damageNTSB 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.Feb 10, 1991 · N77PB · Substantial damageNTSB 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.Feb 10, 1991 · N9651M · Substantial damageNTSB 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.Feb 10, 1991 · N5413D · Substantial damageNTSB 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.Feb 9, 1991 · N3633B · Substantial damageNTSB 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.Feb 9, 1991 · N1065M · DestroyedNTSB 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…Feb 9, 1991 · N2415S · DestroyedNTSB FTW91DPA01Accident · Serious injuriesFinal reportDonald E. Samuels Q2 · Gilmer, TXThe pilot's failure to attain proper climb performance.Feb 9, 1991 · N3147L · DestroyedNTSB 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.Feb 9, 1991 · N758ML · Substantial damageNTSB 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.Feb 9, 1991 · N4450C · Substantial damageNTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.Feb 9, 1991 · N3353H · Substantial damageNTSB 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.Feb 8, 1991 · N7278R · Substantial damageNTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.Feb 8, 1991 · N8510P · DestroyedNTSB 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.Feb 7, 1991 · N13654 · Substantial damageNTSB 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…Feb 7, 1991 · N80JB · DestroyedNTSB MIA91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150G · La Belle, FLTotal loss of engine power due to undetermined reasons.Feb 7, 1991 · N2481J · Substantial damageNTSB 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.Feb 7, 1991 · N6205J · Substantial damageNTSB 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.Feb 7, 1991 · N27818 · DestroyedNTSB 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.Feb 7, 1991 · N6247Y · DestroyedNTSB 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).Feb 7, 1991 · N63541 · Substantial damageNTSB SEA91LA048Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Draper, UTAn undetermined loss of engine power.Feb 6, 1991 · N392X · Substantial damageNTSB 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.Feb 6, 1991 · N9433U · Substantial damageNTSB 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.Feb 6, 1991 · N3966X · DestroyedNTSB 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.Feb 5, 1991 · N5813M · Substantial damageNTSB 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.Feb 5, 1991 · N3822B · DestroyedNTSB 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…Feb 5, 1991 · N6070D · Minor damageNTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.Feb 4, 1991 · N63644 · Substantial damageNTSB 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.Feb 4, 1991 · N6337H · Substantial damageNTSB 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.Feb 4, 1991 · N55263 · Substantial damageNTSB 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.Feb 4, 1991 · N6152W · Substantial damageNTSB 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…Feb 3, 1991 · N8531B · DestroyedNTSB MIA91WA079Accident · No injuriesForeign investigationBeech B36TC · Pitts Town, BahamasFeb 3, 1991 · N6650H · Substantial damageNTSB MIA91LA077Accident · No injuriesLimited investigationFinal reportRyan Navion · Lake City, FLIn-flight encounter with wind shear while on short final resulting in a hard landing.Feb 3, 1991 · N4154K · Substantial damageNTSB 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.Feb 3, 1991 · N99483 · Substantial damageNTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.Feb 3, 1991 · N969X · Substantial damageNTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.Feb 3, 1991 · N13408 · Substantial damageNTSB 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.Feb 3, 1991 · N9713E · Substantial damageNTSB 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.Feb 3, 1991 · N5516M · Substantial damageNTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.Feb 3, 1991 · N4676R · 2 aircraft · DestroyedNTSB 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…Feb 3, 1991 · N224JH · Substantial damage