NTSB investigations, MA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations, MA per year, 1984–2026: 3 cases
1984	2
1987	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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…Jun 6, 1987 · N187P · Minor damage NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…Mar 24, 1984 · N2080P · Substantial damage NTSB NYC84FA064Accident · No injuriesField investigationFinal reportCanadair CL44D4 · East Boston, MAThe acft landed with the right main landing gear in the retracted position. The crew was unable to lower the right main gear by the normal or emergency methods. Inspection after the accident revealed that the main hydraulic line. Pn 44-75087-98 was broken…Jan 2, 1984 · N104BB · Substantial damage