NTSB investigations, IN

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, IN per year, 1982–2026: 10 cases
1982	2
1984	2
1988	1
1995	1
1996	1
1997	2
2006	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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI06CA068Accident · No injuriesData collectionFinal reportCessna 310Q · Griffith, INThe overload failure of the right main landing gear locking mechanism due to undetermined reasons.Jan 15, 2006 · N141DE · Substantial damage NTSB CHI97IA205Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Indianapolis, INthe improper installation of the incorrect spherical bearing by the company's maintenance personnel. A factor was the improper plating of the trunnion with chromium by the landing gear overhaul facility.Jul 9, 1997 · N770AT · Minor damage NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.Apr 3, 1997 · N6148H · Substantial damage NTSB CHI96LA219Accident · No injuriesLimited investigationFinal reportNavion NA1 · Evansville, INthe pilot did not maintain control of the aircraft during landing roll.Jun 26, 1996 · N4096K · Substantial damage NTSB CHI95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Angola, INOverload failure of the right main landing gear shock strut sleeve for an unknown reason.Jan 21, 1995 · N421AW · Substantial damage NTSB CHI88IA096Incident · No injuriesIncident investigationFinal reportSwearingen SA-227AC · Fort Wayne, INInadequate design of the strut for the intended service conditions in commuter air carrier operations.Apr 8, 1988 · N448CA · Minor damage NTSB CHI84LA393Accident · No injuriesLimited investigationFinal reportPickel Smith Miniplane · Covington, INThe pilot stated after the accident that during the landing roll the left wheel separated from the aircraft. The aircraft slid aprx 40 feet and nosed over. The plt stated that he had removed the main landing gear aprx 10 hrs prior to the accident to repack…Sep 18, 1984 · N5023D · Substantial damage NTSB CHI84IA111Incident · No injuriesIncident investigationFinal reportSwearingen SA-26AT · Indianapolis, INThe plt was on a local flt to check the aileron rigging after maintenance had been performed on it. After taking off, he remained in the traffic pattern. On downwind, after extending the landing gear, he noted an unsafe right main gear indication. The plt…Feb 16, 1984 · N175P · Minor damage NTSB CHI83LA033Accident · No injuriesLimited investigationFinal reportCessna 421C · Evansville, INDuring 100 hour inspection a leak was found in the left main landing gear actuator. The seals were replaced and the aircraft was test flown. The gear down green light would not come on during the test but the aircraft was landed uneventfully and put on jacks…Nov 8, 1982 · N98442 · Substantial damage NTSB CHI82DA190Accident · No injuriesFinal reportCessna 310R · Evansville, INAfter the aircraft had touched down from an ILS approach, tower personnel asked the pilot if he could make the first turnoff. Shortly after that, the right gear collapsed when the landing gear rod assembly, pn 0840125-15, failed. A metallurgical examination…May 25, 1982 · N3232M · Substantial damage