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 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.NTSB 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.NTSB MIA96WA098Accident · 8 fatalForeign investigationCessna 402B · Punto Fijo, VenezuelaNTSB LAX96LA133Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAfuel starvation for an undetermined reason.NTSB 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.NTSB ANC96LA033Accident · No injuriesLimited investigationFinal reportCessna 185 · Cripple, AKthe pilot's selection of an unsuitable landing area.NTSB SEA96LA067Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Darrington, WAa ditching of the airplane for undetermined reason(s).NTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.…NTSB 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.NTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruNTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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).NTSB ANC96LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's failure to maintain directional control during landing.NTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX96WA132Accident · 1 fatalForeign investigationCessna 421B · Vigan, PhilippinesNTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB 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.NTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.