NTSB investigations, MS

4 cases where the first occurrence was “Main gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19882026

NTSB investigations, MS per year, 1988–2026: 4 cases
1988	1
1991	1
1993	1
2005	1

Where

Open the map

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."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191) 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.\"eventStateOrRegion\" = 'MS' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 191)
  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."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191)
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 MIA05LA108Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe inadequate maintenance inspection by maintenance personnel which resulted in damaged landing gear pulleys, resulting in the failure of the landing gear downlock to engage, and collapse of the main landing gear during landing.May 24, 2005 · N6654Y · Substantial damage NTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.Feb 6, 1993 · N852DH · Destroyed NTSB MIA91LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Yazoo City, MSSeparation of the right main landing gear during take off due to failure of the bolts which secure the gear to the airframe. Contributing to the accident was the failure of the pilot to abort the takeoff.Sep 14, 1991 · N8999G · Substantial damage NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…Aug 19, 1988 · N73089 · Substantial damage