Maule M-4-220C
NTSB investigations · 113
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 ('5460114')
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 ('5460114')
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 ANC72DAG81Accident · No injuriesClosedMaule M-4 · Skwentna, AKNTSB MKC72DCQ27Accident · No injuriesClosedMaule M-4 · Newton, KSNTSB SEA72DYC16Accident · No injuriesClosedMaule M-4 · Lagrande, ORNTSB MIA72FLD06Accident · No injuriesClosedMaule M-4 · Dunellen, FLNTSB CHI71DEC54Accident · No injuriesClosedMaule 4-220C · Napoleon, MINTSB CHI71FBJ69Accident · No injuriesClosedMaule M-4220 · Midland, MINTSB OAK71DVA41Accident · No injuriesClosedMaule M4-220 · Visalia, CANTSB DEN71DQA10Accident · No injuriesClosedMaule M4-220 · Scholle, NMNTSB OAK71AP010Accident · 1 fatalClosedMaule M4-220 · San Ardo, CANTSB MIA71FLD06Accident · Serious injuriesClosedMaule M-4 · Brandon, FLNTSB MIA70DKJ36Accident · No injuriesClosedMaule M4-220 · Birmingham, ALNTSB ANC69F0006Accident · No injuriesClosedMaule M-4 · Wasilla, AKNTSB OAK68D0315Accident · No injuriesClosedMaule M-4 · San Ardo, CA
Back to Maule M-4-220C