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 CHI96LA106Accident · No injuriesLimited investigationFinal reportCessna 172E · Tofte, MNthe pilot's failure to perform adequate preflight planning which resulted in landing at a closed airport. The snow covered runway was a factor.Mar 14, 1996 · N3898S · Substantial damageNTSB SEA96LA068Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Point Of Rocks, WYthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control due to spatial disorientation. Factors relating to the accident were: the low ceiling and snow.Mar 13, 1996 · N3632T · DestroyedNTSB MIA96WA098Accident · 8 fatalForeign investigationCessna 402B · Punto Fijo, VenezuelaMar 13, 1996 · P4AVB · DestroyedNTSB LAX96LA133Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAfuel starvation for an undetermined reason.Mar 13, 1996 · N8683M · DestroyedNTSB ATL96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Flamingo, FLThe student pilot's selection of unsuitable terrain for a precautionary landing. Failure of the #3 exhaust tube was a related factor.Mar 13, 1996 · N6174Q · Substantial damageNTSB ANC96LA033Accident · No injuriesLimited investigationFinal reportCessna 185 · Cripple, AKthe pilot's selection of an unsuitable landing area.Mar 13, 1996 · N93829 · Substantial damageNTSB SEA96LA067Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Darrington, WAa ditching of the airplane for undetermined reason(s).Mar 12, 1996 · N41MG · Substantial damageNTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.Mar 12, 1996 · N115FH · Substantial damageNTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.Mar 12, 1996 · N2966U · Substantial damageNTSB ATL96LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAthe pilot's improper flare, which resulted in a hard landing, a collapsed nose gear, and a subsequent nose over.Mar 12, 1996 · N105AT · Substantial damageNTSB NYC96LA074Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Shirley, MEthe pilot's fuel mismanagement and improper use of the fuel selector valve which resulted in fuel starvation.Mar 11, 1996 · N712MY · Substantial damageNTSB NYC96FA073Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bridgeport, WVThe pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.Mar 11, 1996 · N222WR · DestroyedNTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.Mar 10, 1996 · N3407R · Substantial damageNTSB LAX96FA131Accident · 2 fatalField investigationFinal reportVarga 2180A · Peoria, AZfailure of the pilot to obtain or maintain adequate airspeed for turning (maneuvering) after takeoff, which resulted in an inadvertent stall/spin. The lack of altitude for stall/spin recovery was a related factor.Mar 10, 1996 · N5065V · DestroyedNTSB FTW96LA144Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Clinton, LAthe pilot's improper positioning of the fuel selector which resulted in fuel starvation. Factors were the dark night light condition and the worn spark plugs.Mar 10, 1996 · N8323N · Substantial damageNTSB FTW96FA143Accident · 1 fatalField investigationFinal reportCessna 150 · Muleshoe, TXimproper planning/decision by the student pilot, and his failure to take adequate remedial action after becoming lost and encountering a low fuel situation, which subsequently resulted in fuel exhaustion, loss of engine power, and a forced landing at night.…Mar 10, 1996 · N66362 · DestroyedNTSB CHI96LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIthe pilot's failure to maintain directional control and his improper use of the rudder in an attempt to regain control.Mar 10, 1996 · N67475 · Substantial damageNTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.Mar 10, 1996 · N6612V · 2 aircraft · Substantial damageNTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).Mar 10, 1996 · N68129 · DestroyedNTSB ATL96LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, TNthe student pilot's improper recovery from a bounced landing and his failure to maintain directional control. A factor was the improper level-off.Mar 10, 1996 · N32421 · Substantial damageNTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.Mar 9, 1996 · N8920S · Substantial damageNTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruMar 9, 1996 · N245GW · DestroyedNTSB MIA96LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe failure of the pilot-in-command to apply caburetor heat before reducing the throttle to simulate an engine failure. Contributing to the accident was the carburetor icing conditions and the unsuitable terrain encountered during the emergency descent.Mar 9, 1996 · N704XQ · Substantial damageNTSB LAX96LA136Accident · No injuriesLimited investigationFinal reportCessna 182Q · Avalon, CAthe pilot's improper flare and improper recovery from a bounced landing. Factors relating to the accident were: a visual illusion due to rising terrain at the approach end of the runway, and the pilot's misjudgment of distance and speed during the approach to…Mar 9, 1996 · N7583S · Substantial damageNTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.Mar 9, 1996 · N5052Y · 2 aircraft · Substantial damageNTSB FTW96LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gladewater, TXfuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.Mar 9, 1996 · N8726N · Substantial damageNTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Mar 9, 1996 · N2681U · Substantial damageNTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.Mar 9, 1996 · N79058 · Substantial damageNTSB LAX96LA129Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Santa Paula, CAfailure of the student pilot to maintain directional control and proper runway alignment during the landing. Factors relating to the accident were: failure of the student to follow the wind limitations of her solo endorsement (written instructions), and the…Mar 8, 1996 · N49048 · Substantial damageNTSB LAX96LA128Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bishop, CAfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve. The unfavorable wind condition was a related factor.Mar 8, 1996 · N5652C · Substantial damageNTSB NYC96LA071Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Philadelphia, PAthe pilot's improper planning/decision, and his resultant flight into known icing conditions, which resulted in ice accumulation, loss of engine power, a forced landing, and subsequent collision with a residence and a vehicle. A factor relating to the…Mar 7, 1996 · N6625P · DestroyedNTSB MIA96FA096Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · Flagler Beach, FLinadequate visual lookout by the pilots in both airplanes, which resulted in their failure to see-and-avoid conflicting traffic.Mar 7, 1996 · N4258T · 2 aircraft · DestroyedNTSB LAX96LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVthe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the flight instructor's inadequate instruction concerning recovery from…Mar 7, 1996 · N5531M · Substantial damageNTSB ATL96LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Livingston, TNFailure of the pilot to see-and-avoid obstructions (electrical lines), while on final approach to land after encountering icing conditions and diverting to a new destination (alternate airport).Mar 7, 1996 · N7913P · Substantial damageNTSB ANC96LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's failure to maintain directional control during landing.Mar 7, 1996 · N9211T · Substantial damageNTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.Mar 6, 1996 · N7451L · No damageNTSB MIA96LA093Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLimproper compensation for wind conditions by the second pilot, his inadequate remedial action after the airplane lifted off during a wind gust, and inadequate supervision by the first pilot (PIC). A factor relating to the accident was: the gusty wind…Mar 5, 1996 · N86928 · Substantial damageNTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.Mar 5, 1996 · N21662 · Substantial damageNTSB NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.Mar 4, 1996 · N61992 · Substantial damageNTSB FTW96LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Sulphur Springs, TXthe pilot's failure to maintain terrain clearance. A factor was his diverted attention to the performance of the manual gear extension procedure.Mar 4, 1996 · N40273 · Substantial damageNTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.Mar 4, 1996 · N7176G · DestroyedNTSB ANC96LA030Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKthe pilot's selection of an unsuitable area for landing. A factor associated with the accident was the rough and uneven terrain.Mar 4, 1996 · N5246E · Substantial damageNTSB ANC96LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ketchikan, AKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of a suitable area for an emergency landing.Mar 4, 1996 · N739YR · Substantial damageNTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.Mar 3, 1996 · N2925V · Substantial damageNTSB MIA96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · Merritt Island, FLThe pilot's inadequate compensation for crosswind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.Mar 3, 1996 · N3311B · Substantial damageNTSB MIA96LA090Accident · No injuriesLimited investigationFinal reportHelio H-295 · Key West, FLThe pilot's inadequate compensation for wind conditions during lift-off, which resulted in the right wingtip contacting the runway. The gusty crosswind was a related factor.Mar 3, 1996 · N68883 · Substantial damageNTSB LAX96WA132Accident · 1 fatalForeign investigationCessna 421B · Vigan, PhilippinesMar 3, 1996 · N69905 · DestroyedNTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.Mar 3, 1996 · N6374L · No damageNTSB CHI96FA099Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Manhattan, KSImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: pressure to meet a work schedule.Mar 3, 1996 · N7065C · Substantial damageNTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.Mar 3, 1996 · N22053 · Substantial damage