Skip to content

NTSB investigations, IN

9 cases where the first occurrence was “Gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

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."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" = 190) 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\" = 190)
  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" = 190)
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 CHI03LA032Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jeffersonville, INThe mechanical binding of the left main landing gear, which resulted in the left main landing gear not fully extending to the down-and-locked position. Factors to the accident were the oleo-strut linkage being corroded and the contamination of the gear…Dec 1, 2002 · N15723 · Substantial damage NTSB CHI00LA161Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe unlocked main landing gear and the manual gear extension not performed by the pilot. The electrical system failure was a contributing factor.Jun 12, 2000 · N7426N · Substantial damage NTSB CHI96LA272Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Poseyville, INthe pilot's improper flare during the landing. A factor relating to the accident was: the pilot's lack of familiarity with the make and model of airplane.Aug 4, 1996 · N3187Z · Substantial damage NTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.Jan 11, 1992 · N15PM · Substantial damage NTSB CHI88LA197Accident · No injuriesLimited investigationFinal reportCessna 310RII · Noblesville, INDuring the landing roll, shortly after touchdown and brake application, the left main landing gear collapsed due to the failure of the drag brace. The pilot was unable to maintain directional control of the aircraft and it veered off the left side of the…Aug 6, 1988 · N98980 · Substantial damage NTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…Nov 14, 1987 · N8382M · Substantial damage NTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…May 2, 1987 · N6401H · Substantial damage NTSB CHI85LA159Accident · No injuriesLimited investigationFinal reportCessna 310B · Shelbyville, INWhen the gear was extended during the apch, a down & locked indication was not obtained. The plt made several attempts to lock the gear down, using both the electrical & manual systems, but was unable. After touchdown, the right main gear collapsed. The acft…Apr 8, 1985 · N5471A · Substantial damage NTSB CHI85LA142Accident · No injuriesLimited investigationFinal reportCessna 172RG · Portland, INUpon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the…Mar 17, 1985 · N9584B · Substantial damage