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 FTW96LA117Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lubbock, TXthe pilot's delay in aborting the takeoff.Feb 14, 1996 · N395T · Substantial damageNTSB SEA96LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Puyallup, WAthe owner's failure to comply with requirements for annual inspections of the airplane, and the debonding of the right brake lining and subsequent jamming of the lining into the right main wheel.Feb 13, 1996 · N71836 · Substantial damageNTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.Feb 13, 1996 · N145ND · Substantial damageNTSB ATL96TA047Accident · Minor injuriesFinal reportPiper PA-32-300 · Windermere, FLthe use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.Feb 13, 1996 · N8951N · Substantial damageNTSB SEA96LA052Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Hubbard, ORthe pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.Feb 12, 1996 · N417DW · Substantial damageNTSB NYC96LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Butler, PAthe pilot's inadequate compensation for wind conditions during the final approach, which resulted in the uncontrolled descent and subsequent collision with the ground. A contributing factor is windshear conditions.Feb 12, 1996 · N89HS · DestroyedNTSB MIA96WA079Accident · 11 fatalForeign investigationAerospace Tech. of Australia N24A · Port-Au-Prince, HaitiFeb 12, 1996 · N224E · DestroyedNTSB ATL96LA046Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Palm City, FLAn improperly adjusted carburetor which resulted in fuel starvation.Feb 12, 1996 · N551MR · DestroyedNTSB MIA96FA078Accident · 3 fatalField investigationFinal reportAero Commander 500S · Manati, PRFailure of the flight crew, for undetermined reasons, to recover from a stall and resulting uncontrolled descent. This resulted in the aircraft colliding with the terrain while in a 45-60 degree nose down attitude at a slow speed.Feb 11, 1996 · N79NU · DestroyedNTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.Feb 11, 1996 · N7358G · Substantial damageNTSB SEA96LA054Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ashland, ORthe dual student's improper touchdown, and the instructor's delayed remedial action. The crosswind was a related factor.Feb 10, 1996 · N690 · Substantial damageNTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.Feb 10, 1996 · N4655F · DestroyedNTSB LAX96LA110Accident · Serious injuriesLimited investigationFinal reportStolp Starduster II · Kahului, HIa faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.Feb 10, 1996 · N1457 · DestroyedNTSB FTW96LA114Accident · No injuriesLimited investigationFinal reportMooney M20M · Alpine, TXThe pilot's failure to maintain airspeed during a misjudged landing flare resulting in a hard landing.Feb 10, 1996 · N9167J · Substantial damageNTSB FTW96FA136Accident · 2 fatalField investigationFinal reportMbb BO-105 · Gulf Of MexicoThe pilot's failure to maintain clearance from the ocean for unknown reasons.Feb 10, 1996 · N126EH · DestroyedNTSB FTW96FA113Accident · 1 fatalField investigationFinal reportCessna 150 · Galveston, TXthe pilot's inadvertent flight into instrument meteorological conditions (IMC), and his failure to sufficient altitude. Factors relating to the accident were: darkness, foggy weather conditions, the pilot's lack of instrument experience, his lack of recent…Feb 10, 1996 · N7973F · DestroyedNTSB CHI96FA088Accident · 1 fatalField investigationFinal reportBell 206B-III · Pellston, MIflight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…Feb 10, 1996 · N2157J · DestroyedNTSB SEA96LA051Accident · No injuriesLimited investigationFinal reportMadorin Kitfox III · Grantsville, UTthe pilot's selection of an unsuitable area for a precautionary landing. A factor was the snow covered terrain.Feb 9, 1996 · N32308 · Substantial damageNTSB MIA96LA077Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Winter Haven, FLFailure of the pilot to maintain control of the aircraft after initiating a go-around, which resulted in the right wing contacting the ground. The unfavorable wind condition was a related factor.Feb 9, 1996 · N6666H · Substantial damageNTSB LAX96LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAthe student pilot's improper use of the rudder control and resultant failure to maintain directional control of the airplane during the landing rollout. Factors relating to the accident were: the student allowed the airspeed to be excessive during the…Feb 9, 1996 · N6321M · Substantial damageNTSB FTW96LA115Accident · No injuriesLimited investigationFinal reportCessna 172G · Gunnison, COLoss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.Feb 9, 1996 · N4262L · Substantial damageNTSB MIA96LA076Accident · No injuriesLimited investigationFinal reportCessna 310L · Auburn, ALan overstress failure of the left main gear side brace lock end fitting for undetermined reasons.Feb 8, 1996 · N2201F · Substantial damageNTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.Feb 8, 1996 · N55329 · Substantial damageNTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.Feb 8, 1996 · N791CR · 2 aircraft · Substantial damageNTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.Feb 8, 1996 · N2795 · Substantial damageNTSB SEA96TA050Accident · No injuriesFinal reportBell 206B · Kemmerer, WYthe selection of an unsuitable landing zone by the pilot.Feb 7, 1996 · N32FR · Substantial damageNTSB NYC96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mattituck, NYthe student pilot's inadequate inflight decision and inadequate evaluation of the weather which resulted in a downwind landing and runway overrun. The student pilot's failure to follow directives was a contributing factor.Feb 7, 1996 · N757PS · Substantial damageNTSB NYC96LA058Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Bradford, PAthe pilot misjudged the flare during landing. Factors in the accident were: an improper recovery from a bounced landing, and the first officers lack of experience in this type operation.Feb 7, 1996 · N159YV · Substantial damageNTSB DCA96RA030Accident · 189 fatalForeign investigationBoeing 757-200 · Puerto Plata, Dominican RepublicFeb 7, 1996 · TCGENNTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.Feb 7, 1996 · N2200J · Substantial damageNTSB SEA96LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Heber City, UTthe pilot's attempted VFR flight into IMC, and his failure to maintain adequate altitude and clearance from terrain during the landing flare. Factors contributing to the accident were the snowbank, fog, and the pilot's complacent attitude.Feb 6, 1996 · N9242C · Substantial damageNTSB LAX96RA116Accident · 8 fatalForeign investigationCessna 550 · Ensenada, MexicoFeb 6, 1996 · XASLQNTSB LAX96LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Barstow, CAfailure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.Feb 6, 1996 · N16726 · Substantial damageNTSB LAX96LA107Accident · No injuriesLimited investigationFinal reportCessna 177 · Corona, CAimproper planning/decision by the pilot-in-command (PIC), and his failure to ensure that adequate airspeed was obtain and/or maintain during lift-off/initial climb. A factor relating to the accident was: the PIC allowed the airplane's maximum gross weight…Feb 6, 1996 · N2386Y · Substantial damageNTSB NYC96LA059Accident · No injuriesLimited investigationFinal reportCessna 180D · Islesboro, MEa loss of engine power for an undetermined reason.Feb 5, 1996 · N6423X · Substantial damageNTSB LAX96FA106Accident · 4 fatalField investigationFinal reportConvair C-131E · Saint Johns, AZinadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…Feb 5, 1996 · N131T · DestroyedNTSB SEA96LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Mcleary, WAfailure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.Feb 4, 1996 · N6750H · Substantial damageNTSB FTW96LA111Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas MD-88 · Denver, COFailure of the pilot to maintain sufficient airspeed to properly flare the airplane during the landing.Feb 4, 1996 · N957DL · Substantial damageNTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.Feb 3, 1996 · N2184Z · No damageNTSB SEA96TA046Accident · Minor injuriesFinal reportChristen Industries A-1 · Lakeview, ORfailure of the pilot to maintain altitude/clearance from the terrain (snow covered, frozen lake). Factors relating to the accident were: the pilot's attention being diverted to a perceived safety hazard, and lack of visual cues for pilot perception of…Feb 2, 1996 · N2866B · Substantial damageNTSB MIA96LA074Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Boynton Beach, FLPilot impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude above the terrain while performing an aerobatic maneuver. Factors relating to the accident were: the pilot's…Feb 2, 1996 · N77YK · DestroyedNTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…Feb 2, 1996 · N204AA · Substantial damageNTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.Feb 1, 1996 · N90194 · Substantial damageNTSB FTW96FA145Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Estes Park, CODescent into mountainous terrain for reasons undetermined.Feb 1, 1996 · N83809 · DestroyedNTSB ATL96FA043Accident · No injuriesField investigationFinal reportDouglas DC-9-32 · Nashville, TNthe failure of the right main landing gear shock strut cylinder due to preexisting fractures. Contributing to the accident was: the failure of the operator to inspect the shock strut cylinder for fractures following a previous failure of the torque links, and…Feb 1, 1996 · N903VJ · Substantial damageNTSB LAX96FA105Accident · 3 fatalField investigationFinal reportBeech E90 · Flagstaff, AZfailure of the pilot to follow prescribed IFR procedures and his failure to maintain control of the aircraft. Factors relating to the accident were: the adverse weather conditions with icing and turbulence.Jan 31, 1996 · N300SP · DestroyedNTSB CHI96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Marion, INthe pilot's failure to maintain directional control during landing.Jan 31, 1996 · N800TC · Substantial damageNTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.Jan 29, 1996 · N6569H · DestroyedNTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…Jan 29, 1996 · N999CR · DestroyedNTSB LAX96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hilo, HIInadequate supervision of the student pilot by the flight instructor during an attempted go-around from a balked landing, which resulted in a loss of directional control and collision with a distance remaining marker.Jan 28, 1996 · N7358Y · Substantial damage