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 DEN76DTC24Accident · No injuriesClosedAeronca 7AC · Lander, WYNTSB CHI76FET28Accident · No injuriesClosedAeronca 65-CA · Michigan City, INNTSB NYC76AN079Accident · 1 fatalClosedTaylorcraft BC12-D · Minorsville, PANTSB CHI76FEV25Accident · No injuriesClosedTaylorcraft BC12-D · Jacksonville, ILNTSB MKC76DER51Accident · No injuriesClosedPiper J3C-65 · Lino Lakes, MNNTSB IAD76DKM23Accident · No injuriesClosedLuscombe 8E · Greensboro, NCNTSB CHI76DEP23Accident · Minor injuriesClosedTaylorcraft BC12-D · Chambers Isle, WINTSB FTW76DQG50Accident · Serious injuriesClosedDavis DA-5 · Stanton, TXNTSB SEA76FYC27Accident · No injuriesClosedLuscombe 8A · Albany, ORNTSB MKC76FCG41Accident · No injuriesClosedLuscombe 8A · Independence, MONTSB ANC76DAG76Accident · Serious injuriesClosedPiper PA-11 · Dillingham, AKNTSB SEA76DYI13Accident · No injuriesClosedPiper J-3 · Medford, ORNTSB OAK76DVM21Accident · No injuriesClosedLuscombe 8A · Watsonville, CANTSB CHI76AC042Accident · 1 fatalClosedPiper J-3 · Hopedale, OHNTSB NYC76DNA23Accident · No injuriesClosedMooney M-18C · Falmouth, MANTSB LAX76FUD06Accident · No injuriesClosedPiper J-3 · Santa Monica, CANTSB ANC76DAG28Accident · Minor injuriesClosedAeronca 11AC · Telida, AKNTSB OAK76FVM19Accident · No injuriesClosedPiper J-3 · Saratoga, CANTSB DEN76FTC22Accident · Serious injuriesClosedPiper J-3 · Gillette, WYNTSB FTW76DPG38Accident · No injuriesClosedTaylorcraft BC12-D · De Witt, ARNTSB MKC76FCJ19Accident · Serious injuriesClosedPiper J-3 · Neligh, NENTSB NYC76FNE12Accident · Serious injuriesClosedAeronca 7AC · Charlton, MANTSB NYC76DFA20Accident · No injuriesClosedPiper J-3 · Cambridge, NYNTSB MKC76DTK14Accident · No injuriesClosedAeronca 11AC · Oelrichs, SDNTSB DEN76FQA29Accident · No injuriesClosedTaylorcraft BC12-D · Farmington, NMNTSB DEN76FTE41Accident · No injuriesClosedTaylorcraft BC12-D · Aurora, CONTSB FTW76FRD20Accident · No injuriesClosedPiper J3C-65 · Melville, LANTSB MKC76FCD20Accident · Minor injuriesClosedLuscombe 8A · Missouri Vally, IANTSB LAX76AL034Accident · 1 fatalClosedAeronca 7AC · Missing AircraftNTSB NYC76FHM13Accident · No injuriesClosedAeronca 7AC · Erwinna, PANTSB IAD76DKM14Accident · No injuriesClosedTaylorcraft BCL2-D · Wilkesboro, NCNTSB NYC76FNC30Accident · Minor injuriesClosedLuscombe 8E · Milton, VTNTSB MIA76FKT24Accident · Minor injuriesClosedPiper J-3 · Indiantown, FLNTSB FTW76DRG27Accident · No injuriesClosedPiper PA-11 · Chapman Ranch, TXNTSB SEA76FTI12Accident · No injuriesClosedTaylorcraft BC12-D · Hamilton, MTNTSB NYC76FFJ08Accident · Serious injuriesClosedAeronca 7AC · Albion, NYNTSB MIA76DKQ17Accident · No injuriesClosedAeronca 7AC · Hollandale, MSNTSB MKC76FCG20Accident · Serious injuriesClosedPiper J3C · Cameron, MONTSB MIA76FKG21Accident · No injuriesClosedAeronca 7AC · Stone Mountain, GANTSB MIA76FKT14Accident · Serious injuriesClosedPiper J-3 · Clewiston, FLNTSB DEN76FTE22Accident · Minor injuriesClosedAeronca 058B · Aurora, CONTSB SEA76FYC14Accident · No injuriesClosedLuscombe 8A · Vancouver, WANTSB MKC76FCG48Accident · No injuriesClosedAeronca 65-CA · Atchison, KSNTSB MKC76DCG16Accident · Minor injuriesClosedPiper J-3 · Sedalia, MONTSB CHI76FEK03Accident · Minor injuriesClosedTaylorcraft BC12-D · Georgesville, OHNTSB CHI76FEG03Accident · No injuriesClosedLuscombe 8A · Blue Ash, OHNTSB MKC76DCQ08Accident · No injuriesClosedHegy RCH-1 · Uniontown, KSNTSB FTW76FPG14Accident · 1 fatalClosedTaylorcraft BC12-D · Little Rock, ARNTSB NYC76FNE03Accident · Minor injuriesClosedPiper J-3 · S Deerfield, MANTSB MIA76DLA02Accident · No injuriesClosedLuscombe 8A · Jacksonville, FL
Back to Continental A&C65 series