Fatal NTSB investigations: Great Lakes 2T-1A-2
8 cases on aircraft the registry lists as Great Lakes 2T-1A-2. 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 2024 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3910101'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3910101'))
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 GAA24WA280Accident · 1 fatalClass 5 · ForeignGreat Lakes 2T-1A-2 · Gütersloh, GermanyNTSB NYC95LA194Accident · 2 fatalLimited investigationFinal reportGreat Lakes 2T1-A2 · Fombell, PAthe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB FTW86FA156Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Houston, TXThe ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in…NTSB LAX82FA361Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Arcata, CAThe plt & pax were on a cross-country from somewhere in the klamath, CA area to hayward, CA. Witnesses observed it flying southbound at 50 to 100 ft over the ocean's shore line. Reportedly, the acft made a sharp left turn toward land, then crashed on a…NTSB FTW81FA115Accident · 1 fatalClosedGreat Lakes 2T-1A2 · Jacktown, OKNTSB IAD79FLQ21Accident · 2 fatalClosedGreat Lakes 2T-1A · Versailles, KYNTSB MKC78FA064Accident · 1 fatalClosedGreat Lakes 2T-1A · Mason City, IANTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJ