NTSB investigations, 2024
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE year(c.\"eventDate\") = 2024 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 WHERE year(c."eventDate") = 2024 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 WPR25LA063Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORAn improper altitude indication from a recent software update, which resulted in a loss of engine power in flight.NTSB WPR25FA062Accident · 1 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B3 · Potrero, CAThe pilot’s loss of control during cruise flight due to incapacitation for reasons that could not be determined.NTSB DCA25WA059Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Derby, United KingdomNTSB CEN25LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCapella FW1C50 · Ozark, MOThe pilot’s failure to maintain aircraft control during high-speed taxi.NTSB GAA25WA043Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Los Lagos, ChileNTSB GAA25WA042Accident · 1 fatalClass 5 · ForeignChampion 8KCAB · Vélez-Málaga, SpainNTSB ERA25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Englishtown, NJThe high wing airplane flight crew’s failure to maintain directional control while taxiing, which resulted in a collision with the stationary low wing airplane.NTSB WPR25LA061Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Gig Harbor, WAThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB GAA25WA045Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Santiago, ChileNTSB ENG25WA023IncidentClass 5 · ForeignBoeing 747 · Karachi, PakistanNTSB WPR25LA060Accident · Minor injuriesClass 3 · LimitedFinal reportZall Jihlavan Airplanes S R O JA-600 Skyleader · Reedley, CAThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA25WA059Accident · 1 fatalClass 4 · ForeignPiper PA25 · Nova Monte, BrazilNTSB ERA25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Jefferson, GAThe airplane’s collision with a deer on the runway during landing.NTSB ERA25LA077Accident · No injuriesClass 4 · LimitedFinal reportWolstenholme Dennis Pietenpol AIR Camper · Tullahoma, TNThe pilot’s failure to adequately secure the airplane before hand-propping the engine. Contributing was the pilot’s lack of training in hand-propping procedures.NTSB ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…NTSB ENG25WA058IncidentClass 5 · ForeignATR ATR72 · Zagreb, CroatiaNTSB CEN25LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Crystal, MNThe malfunction of the landing gear system which resulted in a collapse of the main landing gear during the landing roll.NTSB GAA25WA040AccidentClass 5 · ForeignCessna 172 · Örebro, SwedenNTSB ERA25LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Atlanta, GAThe vehicle driver’s inadequate visual lookout while driving on a non-licensed vehicle roadway in restricted visibility conditions, which resulted in a collision with a taxiing airplane.NTSB DCA25WA058AccidentClass 3 · ForeignBoeing 737 · Abuja, NigeriaNTSB CEN25LA060Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Victoria, TXThe pilot’s inadequate preflight planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB WPR25LA058Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Los Alamitos, CAThe student pilot’s failure to maintain directional control during a run-on landing and the flight instructor’s excessive correction which resulted in impact with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA25WA060Accident · Minor injuriesClass 5 · ForeignCessna 182 · Paranagua, BrazilNTSB CEN25LA058Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Smithville, TXA loss of engine power for undetermined reasons.NTSB WPR25LA057Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Glendale, AZThe pilot's failure to maintain directional control during the landing roll. .NTSB GAA25WA041Accident · No injuriesClass 5 · ForeignCessna 188 · Barra Bonita, BrazilNTSB ERA25LA072Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Pahokee, FLThe pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.NTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR25LA059Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · El Cajon, CAThe pilot’s inability to maintain directional control during landing with a flat tire.NTSB GAA25WA039Accident · Serious injuriesClass 5 · ForeignCessna Cessna FA 150L · Watorowo, PolandNTSB DCA25WA053IncidentClass 5 · ForeignBoeing 767 · Bogotá, ColombiaNTSB CEN25FA056Accident · Serious injuriesClass 3 · FieldFinal reportZenith Zodiac CH601 · Columbia, ILThe pilot’s failure to secure the engine oil filter following maintenance, which resulted in oil starvation, a total loss of engine power, and impact with terrain.NTSB ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB ERA25FA069Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-12IS · Homosassa, FLOn December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight…NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB ENG25WA014IncidentClass 5 · ForeignHawker Hawker 900 · Abuja, NigeriaNTSB CEN25LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150L · Meridian, MSThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate verification of his student’s preflight planning.NTSB WPR25LA056Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Marysvale, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB WPR25LA055Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV14 · Palmdale, CAOn December 15, 2024, about 1303 pacific standard time, an experimental amateur built Vans RV-14, N144SD, was substantially damaged when it was involved in an accident near Palmdale, California. The pilot was not injured. The airplane was operated as a Title…NTSB GAA25WA038Accident · Serious injuriesClass 5 · ForeignThrush S2R · Teyman, IsraelNTSB DCA25WA052Incident · No injuriesClass 5 · ForeignBoeing MD 10-30F · Santa Cruz, BoliviaNTSB WPR25LA054Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150L · Glen Avon, OROn December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA037Accident · 1 fatalClass 5 · ForeignRobinson R44 · Maimuru, AustraliaNTSB ERA25FA065Accident · 1 fatalClass 3 · FieldPreliminary reportTruitt James B Vans RV-8A · Fort Blackmore, VAOn December 4, 2024, about 1451 eastern standard time, an experimental amateur-built Vans RV-8A, N627TT, was substantially damaged when it was involved in an accident near Fort Blackmore, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB ENG25WA011IncidentClass 5 · ForeignAirbus A330 · Los Angeles, CANTSB ENG25WA013OccurrenceClass 5 · ForeignBoeing 737-9 · Cancún, MexicoNTSB DCA25LA055Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean, Hong Kong SAR ChinaAn encounter with unexpected turbulence during descent.NTSB WPR25LA053Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 690D · Spokane, WAA partial loss of engine(s) power due ice ingestion.NTSB GAA25WA036Accident · Serious injuriesClass 5 · ForeignCessna 340A · Magny-lès-Villers, France