Skip to content

NTSB investigations: Continental A&C65 series

3,024 cases on aircraft whose registry engine model is Continental A&C65 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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.engine_model_code IN ('17003')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.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_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.engine_model_code IN ('17003'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA67F0005Accident · No injuriesClosedTaylorcraft BC12D · Mooresville, NCJun 26, 1966 · N39275 · Substantial damage NTSB DEN67D0034Accident · No injuriesClosedLuscombe 8A · Santa Rosa, NMJun 25, 1966 · N28567 · Substantial damage NTSB MIA66F0622Accident · No injuriesClosedLuscombe 8 · Dunedin, FLJun 24, 1966 · N71185 · Substantial damage NTSB CHI67F0165Accident · No injuriesClosedTaylorcraft BC12-D · Alma, MIJun 22, 1966 · N43863 · Substantial damage NTSB NYC67D0044Accident · Minor injuriesClosedLuscombe 8E · Matamoras, PAJun 21, 1966 · N77944 · Substantial damage NTSB MIA66F0610Accident · No injuriesClosedLuscombe 8A · Meridian, MSJun 20, 1966 · N1057K · Substantial damage NTSB CHI67D0121Accident · No injuriesClosedLuscombe 8A · Mukwonago, WIJun 19, 1966 · N71157 · Substantial damage NTSB DEN66F0037Accident · No injuriesClosedLuscombe 8A · Akron, COJun 15, 1966 · N1434B · Substantial damage NTSB CHI67F0032Accident · No injuriesClosedAeronca 11AC · Kalamo, MIJun 12, 1966 · N85825 · Substantial damage NTSB CHI67F0123Accident · No injuriesClosedTaylorcraft BC12D · Lombard, ILJun 11, 1966 · N96275 · Substantial damage NTSB CHI66D0768Accident · No injuriesClosedPiper J3 · New Carlisle, OHJun 7, 1966 · N26923 · Substantial damage NTSB NYC67F0027Accident · No injuriesClosedLuscombe 8A · Palmyra, VAJun 4, 1966 · N2095B · Substantial damage NTSB OAK66D0301Accident · No injuriesClosedAeronca 11AC · Hanford, CAMay 30, 1966 · N86150 · Substantial damage NTSB NYC67D0008Accident · No injuriesClosedPiper J3 · Laconia, NHMay 30, 1966 · N98536 · Substantial damage NTSB CHI67F0020Accident · No injuriesClosedMooney M-18C · Speedway, INMay 30, 1966 · N4061 · Substantial damage NTSB NYC67F0011Accident · No injuriesClosedPiper J3 · East Quogue, NYMay 29, 1966 · N42856 · Substantial damage NTSB MKC67F0132Accident · No injuriesClosedPiper J-3 · Waldron, MOMay 29, 1966 · N42446 · Substantial damage NTSB NYC67F0023Accident · No injuriesClosedForney 415C · Northeast, PAMay 28, 1966 · N37113 · Substantial damage NTSB MKC67F0235Accident · No injuriesClosedLuscombe 8A · Fenton, MOMay 28, 1966 · N28586 · Substantial damage NTSB MKC66D0580Accident · No injuriesClosedLuscombe 8A · Aurora, MOMay 28, 1966 · N1231K · Substantial damage NTSB CHI66F0774Accident · No injuriesClosedAeronca 11AC · Auburn, INMay 23, 1966 · N85772 · Substantial damage NTSB MKC66D0576Accident · No injuriesClosedAeronca 11AC · Clinton, MOMay 22, 1966 · N9284E · Substantial damage NTSB FTW66A0107Accident · 2 fatalClosedPiper J3C-65 · Clarksville, TXMay 21, 1966 · N7080H · Destroyed NTSB FTW66A0106Accident · 1 fatalClosedPiper J-3 · Corning, ARMay 19, 1966 · N98459 · Destroyed NTSB NYC66F0660Accident · No injuriesClosedAeronca 7AC · Pelham, NHMay 8, 1966 · N84242 · Substantial damage NTSB MIA66F0565Accident · No injuriesClosedLuscombe 8A · Leesburg, FLMay 7, 1966 · N71776 · Substantial damage NTSB FTW66F0658Accident · No injuriesClosedPiper J3C-65 · Lubbock, TXMay 5, 1966 · N6323H · Substantial damage NTSB NYC66D0680Accident · No injuriesClosedPiper J3C · New Hamburg, NYMay 2, 1966 · N38527 · Substantial damage NTSB OAK66F0283Accident · Serious injuriesClosedAeronca 7AC · Nipomo Mesa, CAMay 1, 1966 · N83483 · Destroyed NTSB LAX66F0337Accident · No injuriesClosedLuscombe 8B · Wellington, NVMay 1, 1966 · N39091 · Substantial damage NTSB NYC66F0626Accident · No injuriesClosedAeronca 65-TAC · Moneta, VAApr 23, 1966 · N36570 · Destroyed NTSB CHI66D0702Accident · No injuriesClosedPiper PA-17 · Lafayette, INApr 22, 1966 · N4495H · Substantial damage NTSB SEA66D0266Accident · No injuriesClosedAreonca 7AC · Harrisburg, ORApr 19, 1966 · N84745 · Substantial damage NTSB SEA67D0001Accident · No injuriesClosedAeronca 7AC · Ocean Shores, WAApr 17, 1966 · N84312 · Substantial damage NTSB LAX66F0307Accident · Minor injuriesClosedLuscombe 8A · San Diego, CAApr 17, 1966 · N71263 · Substantial damage NTSB LAX66D0352Accident · No injuriesClosedAeronca 7AC · Pacoima, CAApr 17, 1966 · N85784 · Substantial damage NTSB MIA66F0491Accident · No injuriesClosedLuscombe 8A · Clearwater, FLApr 12, 1966 · N45523 · Substantial damage NTSB LAX66D0308Accident · Minor injuriesClosedPiper J-3 · Alpine, CAApr 6, 1966 · N42614 · Substantial damage NTSB MIA66F0520Accident · No injuriesClosedLuscombe 8A · Fort Pierce, FLMar 31, 1966 · N1439B · Substantial damage NTSB FTW66D0607Accident · No injuriesClosedPiper J3 · Mt Home, ARMar 31, 1966 · N42733 · Substantial damage NTSB SEA66D0257Accident · No injuriesClosedAeronca 7AC · Spanaway, WAMar 22, 1966 · N2132E · Substantial damage NTSB NYC66F0673Accident · Minor injuriesClosedAeronca 7AC · Union, WVMar 21, 1966 · N2732E · Destroyed NTSB MIA66D0469Accident · No injuriesClosedAeronca 11AC · Sebring, FLMar 20, 1966 · N3891E · Substantial damage NTSB MIA66F0483Accident · Serious injuriesClosedLuscombe 8A · Griffin, GAMar 19, 1966 · N2160B · Substantial damage NTSB MKC66D0455Accident · No injuriesClosedTaylorcraft BC12-D · Kirksville, MOMar 18, 1966 · N5020M · Substantial damage NTSB NYC66F0555Accident · No injuriesClosedPiper J-3C · Clyde, NYMar 14, 1966 · N92378 · Substantial damage NTSB MIA66A0104Accident · 1 fatalClosedPiper J3C-65 · Central Falls, NCMar 13, 1966 · N70434 · Destroyed NTSB MKC66F0442Accident · No injuriesClosedPiper J3C-65 · Broken Bow, NEMar 11, 1966 · N4790T · Substantial damage NTSB NYC66F0560Accident · No injuriesClosedAeronca 7AC · Claremont, NHMar 8, 1966 · N84522 · Substantial damage NTSB SEA66D0235Accident · No injuriesClosedPiper J3C · Lewiston, MTFeb 27, 1966 · N88253 · Substantial damage