NTSB investigations: Meyers Industries 200A
13 cases on aircraft the registry lists as Meyers Industries 200A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2021 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5650304'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5650304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.NTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.NTSB CHI01LA112Accident · No injuriesLimited investigationFinal reportMeyers 200A · Tecumseh, MIThe fuel starvation. Factors were the loose line at the distribution valve, the inadequate annual inspection the owner/pilot mechanic performed, the unsuitable terrain the pilot encountered during the emergency landing after takeoff, and the trees.NTSB FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW80DRA14Accident · No injuriesClosedMeyers 200 · La Porte, TXNTSB NYC77FGM20Accident · No injuriesClosedMeyers 200A · West Mifflin, PANTSB CHI77FEC18Accident · No injuriesClosedMeyers 200A · Monroe, MINTSB CHI71FEI46Accident · Serious injuriesClosedMeyers 200-A · Vermilion, OHNTSB OAK70F0098Accident · No injuriesClosedMyers 200A · Vacaville, CANTSB SEA67D0239Accident · Minor injuriesClosedMeyers 200-A · Pomeroy, WANTSB LAX66F0160Accident · No injuriesClosedMeyers 200A · Hawthorne, CANTSB CHI65F0114Accident · No injuriesClosedMeyers 200A · Kokomo, INNTSB UNK64X1410Accident · No injuriesClosedMeyers 200A · Washington, DC