Ongoing NTSB investigations
34 cases where the sequence of events included Hard landing.
Cases per year
| 2024 | 1 |
|---|---|
| 2025 | 9 |
| 2026 | 24 |
Where
Open the mapLatest cases
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 c.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 c."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA27LA014Accident · No injuriesLimited investigationInvestigation openTextron 172S · Jacksonville, FLNTSB ERA27LA013Accident · No injuriesClass 3 · LimitedInvestigation openHughes 269C · Gastonia, NCNTSB ERA27LA020AccidentLimited investigationInvestigation openCessna 162 · Fort Lauderdale, FLNTSB CEN27LA008Accident · No injuriesClass 4 · LimitedInvestigation openCessna 175A · Hastings, MINTSB CEN27LA007Accident · No injuriesClass 4 · LimitedInvestigation openKitfox III · Ward, ARNTSB WPR26LA368Accident · No injuriesClass 4 · LimitedInvestigation openGronberger Sergio A Sportsman GS-2 · Lake Goodwin, WANTSB ERA26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182S · St. Petersburg, FLNTSB ERA26LA353Accident · No injuriesClass 4 · LimitedInvestigation openRoberts GS-2 Sportsman · Kerrtown, PANTSB WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB ERA26LA352Accident · No injuriesClass 4 · LimitedInvestigation openHart Frank RV-8A · Sanford, NCNTSB WPR26LA339Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Santa Teresa, NMNTSB WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CANTSB WPR26LA328Accident · No injuriesClass 3 · LimitedPreliminary reportBell OH-58A · Phoenix, AZOn September 3, 2026, about 0932 mountain standard time, a Bell OH-58, N480FT, sustained substantial damage when it was involved in an accident near Deer Valley, Arizona. The pilots did not sustain any injuries. The helicopter was operated as a Title 14 Code…NTSB ERA26LA298Accident · No injuriesClass 4 · LimitedInvestigation openPeckham Lloyd Zodiac CH-650B · Westerly, RINTSB CEN26LA276Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Bennett, IAOn August 2, 2026, about 1318 central daylight time, a Robinson Helicopter Company R44 II helicopter, N26KL, was substantially damaged when it was involved in an accident near Bennett, Iowa. The pilot was not injured. The helicopter was operated as a Title 14…NTSB WPR26LA283Accident · No injuriesClass 4 · LimitedInvestigation openCub Crafters CCX-2000 · Tooele, UTNTSB WPR26LA271Accident · No injuriesClass 4 · LimitedInvestigation openLet L-23 Super Blanik · North Plains, ORNTSB WPR26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportLuscombe 8A · Novato, CAOn July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA254Accident · No injuriesClass 3 · LimitedPreliminary reportRath Michael J Sonerai 2 · Cynthiana, KYOn June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB ANC26LA056Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-22-160 · Russian Mission, AKNTSB ERA26LA340Accident · No injuriesClass 4 · LimitedInvestigation openJames P Donovan Sportsman GS-2 · Winter Haven, FLNTSB DCA26LA097Accident · No injuriesClass 4 · LimitedInvestigation openBoeing 767 · San Bernardino, CANTSB CEN26LA087Accident · Minor injuriesClass 3 · LimitedPreliminary reportStinson 108-3 · Gypsum, COOn January 11, 2026, at 1408 mountain standard time, a Stinson 108-3 airplane, N6725M, sustained substantial damage when it was involved in an accident near Gypsum, Colorado. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26FA084Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Provincetown, MAOn January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA050Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-46-701TP · Provo, UTOn November 24, 2025, at 1529 Pacific daylight time, a Piper Aircraft Inc. PA-46-701TP (Fury), N646U, was substantially damaged when it was involved in an accident in Provo, Utah. The pilot was seriously injured and the three passengers sustained minor…NTSB WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA006Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SM 1019 · Richland, WAOn October 2, 2025, about 1050 Pacific daylight time, a Siai-Marchetti SM 1019, N3172U, sustained substantial damage when it was involved in an accident near Richland, Washington. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB CEN25LA408Accident · No injuriesClass 3 · LimitedPreliminary reportBell Helicopter Textron Canada 206L-3 · Picayune, MSOn August 22, 2025, about 1130 central daylight time, a Bell Helicopter Textron Canada 206L-3 helicopter, N17TL, was substantially damaged when it was involved in an accident near Picayune, Mississippi. The pilot and passenger were not injured. The helicopter…NTSB WPR25LA207Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182B · Belen, NMOn July 4, 2025, about 0900 mountain daylight time, a Cessna 182B, N7166E, was substantially damaged when it was involved in an accident near Belen, New Mexico. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA163Accident · No injuriesClass 3 · LimitedPreliminary reportRans S20 · Fairfield, UTOn May 27, 2025, about 1330 mountain daylight time, an experimental amateur-built RANS S20 Raven, N327KM, was substantially damaged when it was involved in an accident near Fairfield, Utah. The pilot was not injured. The airplane was operated as a Title 14…NTSB DCA25LA184Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus A321-271NX · San Juan, PROn April 15, 2025, about 2140, Atlantic daylight time (ADT), Frontier Airlines, flight 3506, an Airbus A321-271NX, N607FR, sustained nose wheel and engine damage during an attempted landing at the Luis Munoz Marin International Airport (SJU), San Juan, Puerto…NTSB ERA25LA166Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Sanford, FLOn April 3, 2025, about 1222 eastern daylight time, a Cessna 182P, N1910M, was substantially damaged when it was involved in an accident near Sanford, Florida. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN25LA097Accident · Serious injuriesClass 3 · LimitedPreliminary reportDouglas A-20G · Laredo, TXOn February 16, 2025, about 1239 central standard time, a Douglas A-20G airplane, N747HS, was substantially damaged when it was involved in an accident in Laredo, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR24LA323AccidentClass 3 · LimitedPreliminary reportBeech J35 · Belgrade, MTOn August 27, 2024, about 1845 mountain daylight time, a Beech J35, N8350D, was substantially damaged when it was involved in an accident near Belgrade, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…