NTSB investigations: Great Lakes 2T-1A-2
68 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, newest first
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 ('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."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 MKC79DCD27Accident · No injuriesClosedGR Lakes 2T-1A2 · Algona, IANTSB OAK79DVD23Accident · No injuriesClosedGreat Lakes 2T-1A · Willits, CANTSB FTW79FRG05Accident · No injuriesClosedGreat Lakes 2T-1A · Fredericksburg, TXNTSB OAK78FVM42Accident · No injuriesClosedGreat Lakes 2T-1A · Santa Cruz, CANTSB MKC78FA064Accident · 1 fatalClosedGreat Lakes 2T-1A · Mason City, IANTSB CHI78FEV47Accident · No injuriesClosedGreat Lakes 2T1A2 · Peoria, ILNTSB LAX78DUQ30Accident · No injuriesClosedGreat Lakes 2T1A-2 · Simi Valley, CANTSB FTW78DPJ23Accident · No injuriesClosedGreat Lakes 2T-1A · Enid, OKNTSB DEN78DQD17Accident · No injuriesClosedGreat Lakes 2T1A-2 · Silver City, NMNTSB LAX78DVM14Accident · No injuriesClosedGR Lakes 2T-1A · Santa Maria, CANTSB LAX78FUQ11Accident · No injuriesClosedBeech B19 · Van Nuys, CANTSB OAK78DVD02Accident · No injuriesClosedGreat Lakes 2THA2 · Oakland, CANTSB FTW77DPG32Accident · No injuriesClosedGreat Lakes 2T-1A · Searcy, ARNTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJNTSB UNK77X0103Accident · Serious injuriesClosedGreat Lakes 2T-1A2 · San Fernando, CANTSB FTW77DPG04Accident · No injuriesClosedGreat Lakes 2T-1A · Van Buren, ARNTSB OAK76DVG99Accident · No injuriesClosedGreat Lakes Baby · Chico, CANTSB LAX75FUQ27Accident · No injuriesClosedGR Lakes 2T-1A2 · Lancaster, CA