Maule M-5-210C
NTSB investigations · 66
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('5460134')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5460134')
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 ANC78DAG73Accident · Minor injuriesClosedMaule M5210C · Homer, AKNTSB ANC77DAH14Accident · No injuriesClosedMaule M-5 · Hayes River, AKNTSB OAK77DXQ10Accident · No injuriesClosedMaule 210C · Kings Riv Vly, NVNTSB ANC77DA020Accident · Minor injuriesClosedMaule M5 · Ft Yukon, AKNTSB ANC76DAA64Accident · No injuriesClosedMaule M-5 · Candle, AKNTSB MKC76DCJ51Accident · Minor injuriesClosedMaule M5210C · Gothenburg, NENTSB ANC76DAA44Accident · Minor injuriesClosedMaule M5210C · Fairbanks, AKNTSB NYC76DHA34Accident · No injuriesClosedMaule M5210C · Andover, NJNTSB SEA76FTI14Accident · Minor injuriesClosedMaule M5210C · Bozeman, MTNTSB ANC76DAG47Accident · No injuriesClosedMaule M-5 · Mt Susitna, AKNTSB ANC76DAG44Accident · No injuriesClosedMaule M-5 · Talkeetna, AKNTSB ANC76DAA13Accident · No injuriesClosedMaule M5 · Northway, AKNTSB SEA76DTI09Accident · No injuriesClosedMaule M-5 · Thompson Falls, MTNTSB ANC76AA006Accident · Serious injuriesClosedMaule M-5 · Lime Village, AKNTSB NYC75FGT20Accident · Minor injuriesClosedMaule M5-210 · Lock Haven, PANTSB MKC75DTK15Accident · No injuriesClosedMaule M5-210 · Wood, SD
Back to Maule M-5-210C