Continental A&C65 series
NTSB investigations · 3,024
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.engine_model_code IN ('17003')
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.engine_model_code IN ('17003')
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 FTW68F0329Accident · Serious injuriesClosedAeronca 7AC · Kingfisher, OKNTSB NYC68F0267Accident · No injuriesClosedTaylorcraft BC12D1 · Waterville, MENTSB MKC68D0392Accident · No injuriesClosedPiper J3C-65 · Lancaster, MONTSB DIA68D0112Accident · No injuriesClosedLuscombe 8A · Thomasville, NCNTSB SEA68F0196Accident · No injuriesClosedLuscombe 8A · Renton, WANTSB NYC68F0300Accident · Serious injuriesClosedTaylorcraft BC12-D · Midway, PANTSB OAK68D0198Accident · No injuriesClosedLuscombe 8A · Tracy, CANTSB MKC68D0361Accident · No injuriesClosedLuscombe 8F · Brainerd, MNNTSB DEN68D0131Accident · No injuriesClosedPiper J-3 · Edgerton, WYNTSB SEA68D0215Accident · No injuriesClosedPiper J3C-65 · Bonanza, ORNTSB CHI68F0370Accident · No injuriesClosedLuscombe 8A · Belleville, ILNTSB CHI68F0361Accident · Minor injuriesClosedAeronca 7AC · Mt.Sterling, OHNTSB MKC68F0323Accident · No injuriesClosedPiper J-3 · Douglas, NDNTSB FTW68O0008Accident · Minor injuriesClosedLuscombe 8A · Mendez, MexicoNTSB DEN68F0129Accident · Minor injuriesClosedTaylorcraft BC-65 · Aztec, NMNTSB SEA68D0162Accident · Minor injuriesClosedTaylorcraft BC12-D · Ketchum, IDNTSB NYC68A0057Accident · 1 fatalClosedPiper J-3 · Spencer, NYNTSB MIA68F0233Accident · Minor injuriesClosedLuscombe 8A · Mcintosh, FLNTSB FTW68F0264Accident · Minor injuriesClosedAeronca 11AC · Benton, ARNTSB MKC68F0303Accident · No injuriesClosedAeronca 65-TC · Langdon, NDNTSB CHI68F0340Accident · Serious injuriesClosedAeronca 7AC · Strongsville, OHNTSB CHI68F0337Accident · No injuriesClosedLuscombe 8A · Muncie, INNTSB SEA68D0144Accident · Minor injuriesClosedTaylorcraft BC12-D · Harrison, MTNTSB MIA68D0193Accident · No injuriesClosedTaylorcraft BC12 · Millry, ALNTSB CHI68F0258Accident · No injuriesClosedSparks D · Marion, OHNTSB SEA68F0139Accident · No injuriesClosedLuscombe 8A · Missoula, MTNTSB NYC68D0249Accident · No injuriesClosedAeronica 7AC · Fredonia, NYNTSB MIA68F0173Accident · No injuriesClosedAeronca 7AC · Cairo, GANTSB OAK68D0139Accident · No injuriesClosedTaylorcraft L-2 · Castroville, CANTSB LAX68D0166Accident · No injuriesClosedTaylorcraft DCO-65 · Pacoima, CANTSB CHI68D0250Accident · No injuriesClosedLuscombe 8A · Richmond, INNTSB DIA68D0114Accident · No injuriesClosedPiper J4A · Jeffersonton, VANTSB MKC68F0195Accident · Serious injuriesClosedStits SA6-B · Grinnell, IANTSB DIA68D0071Accident · No injuriesClosedPiper J-3 · Edgewater, MDNTSB SEA68D0105Accident · No injuriesClosedLuscombe 8A · Deer Park, WANTSB MIA68F0163Accident · No injuriesClosedPiper J3 · Bushnell, FLNTSB NYC68F0209Accident · No injuriesClosedPiper J3C-65 · Mashpee, MANTSB MIA68F0148Accident · Serious injuriesClosedPiper J3C-65 · Hollandale, MSNTSB NYC68D0145Accident · No injuriesClosedTaylorcraft BC12-D · Bethel, MENTSB ANC68D0038Accident · No injuriesClosedAeronca 7AC · Gakona, AKNTSB CHI68A0018Accident · 1 fatalClosedPiper J3 · Medina, OHNTSB FTW68F0132Accident · Minor injuriesClosedAeronca 7AC · Commerce, TXNTSB FTW68F0254Accident · No injuriesClosedLuscombe 8E · Kingsland, TXNTSB CHI68F0195Accident · No injuriesClosedAeronca 11AC · Dayton, OHNTSB NYC68F0244Accident · Minor injuriesClosedAeronca 0-58B · Beaver River, NYNTSB ANC68F0033Accident · No injuriesClosedAeronca 65-CA · Anchorage, AKNTSB NYC68D0122Accident · No injuriesClosedAeronca 11AC · Morrisdale, PANTSB CHI68F0271Accident · No injuriesClosedLuscombe 8A · Alpha, MINTSB DEN68A0010Accident · 2 fatalClosedAerona 11AC · Erie, CONTSB CHI68F0431Accident · Minor injuriesClosedLuscombe 8A · Long Grove, IL
Back to Continental A&C65 series