Skip to content

NTSB investigations

1,787 cases where the sequence of events included Landing gear collapse.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' 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

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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' 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 ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNSep 30, 2026 · N384MA · Substantial damage NTSB ERA26LA354Accident · No injuriesClass 3 · LimitedPreliminary reportCostruzioni Aeronautiche Tecnam P92 Tail Dragger · Toughkenamon, PAOn September 29, 2026, about 0945 eastern daylight time, a special light-sport Costruzioni Aeronautiche Tecnam P92 Tail Dragger, N575TA, was substantially damaged when it was involved in an accident near Toughkenamon, Pennsylvania. The pilot was not injured.…Sep 29, 2026 · N575TA · Substantial damage NTSB CEN26LA329Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-181 · Mason, MISep 26, 2026 · N8086G · Substantial damage NTSB ERA26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna 421B · Nashville, TNSep 25, 2026 · N421FA · Substantial damage NTSB ERA26LA353Accident · No injuriesClass 4 · LimitedInvestigation openRoberts GS-2 Sportsman · Kerrtown, PASep 24, 2026 · N390KC · Substantial damage NTSB ERA26LA349Accident · No injuriesClass 3 · LimitedInvestigation openBeech 200 · Dothan, ALSep 19, 2026 · N621JG NTSB WPR26LA340Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · San Luis Obispo, CAOn September 13, 2026, about 1515 Pacific daylight time, a Cessna P210N airplane, N4617W, was substantially damaged when it was involved in an accident near San Luis Obispo, California. The pilot, pilot-rated-passenger, and a passenger were not injured. The…Sep 13, 2026 · N4617W · Substantial damage NTSB WPR26LA343Accident · No injuriesClass 4 · LimitedInvestigation openAerovodochody L-29 Delfin · Roswell, NMSep 12, 2026 · N29AD · Substantial damage NTSB ANC26LA104Accident · No injuriesClass 4 · LimitedInvestigation openTaylorcraft BL-65 · Ninilchik, AKSep 11, 2026 · N22619 · Substantial damage NTSB WPR26LA334Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 200 · Roswell, NMOn September 8, 2026, about 0044 mountain daylight time, N393JW, a Beech 200, was substantially damaged when it was involved in an accident near Roswell, New Mexico. The two pilots and two of the medical crew members were not injured, a third medical crew…Sep 8, 2026 · N393JW · Substantial damage NTSB ANC26LA099Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-210C · Venetie, AKAug 31, 2026 · N420KB · Substantial damage NTSB ERA26LA321Accident · No injuriesClass 4 · LimitedInvestigation openCessna R182 · Clarksville, TNAug 30, 2026 · N756EB · Substantial damage NTSB GAA26WA307Accident · No injuriesClass 5 · ForeignBeech C90 · Belo Horizonte, BrazilAug 26, 2026 · PP-ADU · Substantial damage NTSB ANC26LA090Accident · No injuriesClass 4 · LimitedInvestigation openRepublic RC-3 · Evansville, INAug 24, 2026 · N463RK · Substantial damage NTSB ERA26LA303Accident · Serious injuriesClass 3 · LimitedPreliminary reportMcfarland Larry C Zenith 601 HDS · Ripley Landing, WVOn August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.…Aug 15, 2026 · N601EZ · Substantial damage NTSB ERA26LA358Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Union City, OHOn August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…Aug 10, 2026 · N6985P · Substantial damage NTSB CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.Aug 3, 2026 · N412CV · Substantial damage NTSB WPR26LA288Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-20 · Reno, NVAug 2, 2026 · N7626K · Substantial damage NTSB ERA26LA280Accident · No injuriesClass 4 · LimitedFinal reportWaco ASO · Hamilton, OHThe separation of the right main landing gear axle, which resulted in a loss of control during the landing roll.Jul 24, 2026 · N119Y · Substantial damage NTSB WPR26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-161 · San Bernardino, CAOn July 18, 2026, about 1530 Pacific daylight time, a Piper PA-28-161, N8249B, was substantially damaged when it was involved in an accident near San Bernardino, California. The pilot and pilot rated passenger were not injured. The airplane was operated as a…Jul 18, 2026 · N8249B · Substantial damage NTSB WPR26LA265Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7A · Covington, WAThe pilot’s improper pitch control during landing, which resulted in a bounced landing, nose landing gear collapse, and nose over.Jul 17, 2026 · N987CW · Substantial damage NTSB WPR26LA279Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24 · Medford, OROn July 14, 2026, about 1725 Pacific daylight time, a Piper PA-24 airplane, N5002P, was substantially damaged when it was involved in an accident at Rogue Valley International/Medford Airport (MFR), Medford. Oregon. The two pilots were not injured. The…Jul 15, 2026 · N5002P · Substantial damage NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.Jul 9, 2026 · N21JB · Substantial damage NTSB DCA26WA281Accident · No injuriesClass 5 · ForeignMcdonnell Douglas MD80 · Dachi Su, KyrgyzstanJul 7, 2026 · EX-80003 NTSB DCA26WA273Accident · No injuriesClass 5 · ForeignDouglas DC9 · Dachi Su, KyrgyzstanJul 7, 2026 · EX-80003 NTSB DCA26WA262Incident · No injuriesClass 4 · ForeignBoeing 737 · Bogotá, ColombiaJul 5, 2026 · HK5447 · Minor damage NTSB WPR26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Paynesville, MNOn June 30, 2026, about 1745 central daylight time, a Beech A36, N8095F, was substantially damaged when it was involved in an accident at Paynesville Municipal Airport (PEX), Paynesville, Minnesota. The private pilot and one passenger were not injured. The…Jun 30, 2026 · N8095F · Substantial damage NTSB WPR26LA230Accident · No injuriesClass 4 · LimitedFinal reportStephen Aberle Chipper CH-2A · Alva, OKThe pilot's decision to taxi the tailwheel-equipped airplane over uneven terrain while operating with limited forward visibility, which resulted in the left main landing gear entering a hole.Jun 21, 2026 · N618SA · Substantial damage NTSB WPR26LA226Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Los Angeles, CAOn June 21, 2026, about 1255 Pacific daylight time, a Cessna TR182, N2194S, sustained substantial damage when it was involved in an accident near Van Nuys, California. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Jun 21, 2026 · N2194S · Substantial damage NTSB ANC26LA058Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182Q · Beaver, AKJun 19, 2026 · N828PB · Substantial damage NTSB CEN26LA229Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Carbondale, ILThe flight instructor’s delayed remedial action during the student pilot’s miscalculated landing flare which resulted in a hard landing and the nose landing gear collapsing.Jun 16, 2026 · N191FS · Substantial damage NTSB ERA26LA246Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 402 · Provincetown, MAOn June 15, 2026, about 0810 eastern daylight time, a Cessna 402C, N499CA, was substantially damaged when it was involved in an accident at Provincetown Municipal Airport (PVC), Provincetown, Massachusetts. The airplane transport pilot (pilot flying) and…Jun 15, 2026 · N499CA · Substantial damage NTSB GAA26WA289Accident · No injuriesClass 4 · ForeignBeech B200 · Rio de Janeiro, BrazilJun 2, 2026 · PS-AKT · Substantial damage NTSB CEN26LA211Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Montevideo, MNA total loss of engine power on approach due to carburetor icing.Jun 1, 2026 · N15291 · Substantial damage NTSB WPR26LA364Accident · No injuriesClass 3 · LimitedInvestigation openCirrus Design SR20 · Phoenix, AZMay 30, 2026 · N447AV NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.May 27, 2026 · N3984F · Substantial damage NTSB ERA26LA228Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Fitchburg, MAThe pilot’s improper landing flare, which resulted in a hard landing.May 26, 2026 · N6287T · Substantial damage NTSB CEN26LA198Accident · No injuriesClass 4 · LimitedFinal reportCommander 114TC · Woodruff, WIThe pilot’s failure to maintain airplane control during the go-around.May 23, 2026 · N114DP · Substantial damage NTSB WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.May 21, 2026 · N261MM · Substantial damage NTSB ERA26LA195Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Bealeton, VAOn May 1, 2026, at 1230 eastern daylight time, an Air Tractor AT-602, N602RH, was substantially damaged when it was involved in an accident near Bealeton, Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…May 1, 2026 · N602RH · Substantial damage NTSB ANC26LA035Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7EC · Hollis, OKApr 30, 2026 · N7436B · Substantial damage NTSB WPR26LA178Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 162 · Everett, WAOn April 25, 2026, at 1026 Pacific daylight time, a Cessna 162, N162HA, sustained substantial damage when it was involved in an accident near Everett, Washington. The flight instructor and student pilot were not injured. The airplane was operated as a Title…Apr 25, 2026 · N162HA · Substantial damage NTSB ERA26LA191Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Sanford, NCA loss of electrical power as a result of broken stator leads within the alternator, which resulted in the pilot’s inability to extend the airplane’s landing gear.Apr 24, 2026 · N85WM · Substantial damage NTSB ANC26LA032Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A185F · Aniak, AKOn April 24, 2026, about 1045 Alaska daylight time, a wheel/ski-equipped Cessna 185 airplane, N92DC, was substantially damaged in an accident at Aniak Airport (ANI), Aniak, Alaska. The pilot and one passenger were not injured. The flight was being operated as…Apr 24, 2026 · N92DC · Substantial damage NTSB GAA26WA291Accident · No injuriesClass 5 · ForeignPiper PA32R · Nakuru, KenyaApr 19, 2026 · 5Y-BRJ · Minor damage NTSB CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.Apr 17, 2026 · N9262Y · Substantial damage NTSB ERA26LA173Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Stevensville, MDThe pilot’s inadvertent retraction of the landing gear lever during the landing roll, which resulted in a gear collapse and runway excursion.Apr 11, 2026 · N38020 · Substantial damage NTSB CEN26LA161Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Seguin, TXThe failure of the landing gear weldment that resulted in separation of the right main landing gear.Apr 7, 2026 · N249CT · Substantial damage NTSB CEN26LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Burke, TXThe airplane’s encounter with unexpected low-level wind shear during final approach, which resulted in a hard impact with the runway.Apr 5, 2026 · N95AG · Substantial damage NTSB ERA26LA163Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA31T · Ocean City, NJOn April 1, 2026, about 1635 eastern daylight time, a Piper PA-31T1, N96MA, was substantially damaged when it was involved in an accident near Ocean City, New Jersey. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…Apr 1, 2026 · N96MA · Substantial damage