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.

NTSB ANC76DAG18Accident · No injuriesClosedLuscombe 8A · Girdwood, AKJul 27, 1975 · N1101B · Substantial damageNTSB MKC76DCJ05Accident · No injuriesClosedAeronca 7AC · Big Springs, NEJul 22, 1975 · N84555 · Substantial damageNTSB MKC76IK010Incident · No injuriesClosedLuscombe 8A · Runnells, IAJul 21, 1975 · N2251B · 2 aircraft · Minor damageNTSB CHI76FEM02Accident · Serious injuriesClosedPiper J3-85C · Acme, MIJul 13, 1975 · N7174H · Substantial damageNTSB MKC76DER06Accident · No injuriesClosedLuscombe 8A · St Croix, MNJul 6, 1975 · N1279K · Substantial damageNTSB IAD76AI001Accident · 2 fatalClosedAeronca 058B · Pikeville, KYJul 5, 1975 · N52354 · DestroyedNTSB MKC76FER02Accident · Serious injuriesClosedAeronca O-58B · Jordon, MNJul 4, 1975 · N47336 · Substantial damageNTSB MKC76FCG05Accident · No injuriesClosedWood CR-1 · Blue Eye, MOJul 4, 1975 · N2752C · Substantial damageNTSB CHI76FEP01Accident · Serious injuriesClosedLuscombe 8A · Montello, WIJul 4, 1975 · N77887 · Substantial damageNTSB NYC75DFA45Accident · No injuriesClosedAeronca 7AC · Oneonta, NYJun 27, 1975 · N85227 · Substantial damageNTSB NYC75FGM47Accident · Minor injuriesClosedLuscombe 8A · Leechburg, PAJun 21, 1975 · N1544K · Substantial damageNTSB NYC75FFJ24Accident · Serious injuriesClosedPiper J-3 · Gasport, NYJun 15, 1975 · N6880H · DestroyedNTSB CHI75FEP46Accident · Minor injuriesClosedLuscombe 8A · Burlington, WIJun 14, 1975 · N45974 · Substantial damageNTSB DEN75FTM16Accident · No injuriesClosedLuscombe 8A · Salt Lake City, UTJun 12, 1975 · N72078 · Substantial damageNTSB NYC75AN117Accident · 2 fatalClosedAeronca 7AC · Macungie, PAJun 10, 1975 · N2630E · 2 aircraft · Substantial damageNTSB CHI75FEC54Accident · No injuriesClosedPiper J3 · Ann Arbor, MIJun 8, 1975 · N21647 · Substantial damageNTSB MKC75FCJ58Accident · No injuriesClosedAeronca 7AC · Lincoln, NEJun 7, 1975 · N83469 · No damageNTSB MKC75DTK21Accident · No injuriesClosedLuscombe 8A · Hoven, SDJun 6, 1975 · N77859 · Substantial damageNTSB CHI75DEE64Accident · Serious injuriesClosedTaylorcraft BC12-D · Chicago Hts, ILMay 26, 1975 · N95278 · Substantial damageNTSB CHI75DEG23Accident · No injuriesClosedPiper J-3 · Minford, OHMay 25, 1975 · N2081M · Substantial damageNTSB LAX75FUQ29Accident · No injuriesClosedAeronca 7AC · Pacoima, CAMay 23, 1975 · N83167 · Substantial damageNTSB CHI75DEM43Accident · No injuriesClosedLuscombe 8A · Oshtemo, MIMay 23, 1975 · N71101 · Substantial damageNTSB SEA75FTA20Accident · No injuriesClosedPiper PA-11 · Nashua, MTMay 18, 1975 · N4752M · Substantial damageNTSB NYC75FNE37Accident · No injuriesClosedAeronca 7AC · Gardner, MAMay 18, 1975 · N85387 · Substantial damageNTSB MKC75DTK18Accident · Minor injuriesClosedAeronca 7AC · Canton, SDMay 18, 1975 · N85133 · Substantial damageNTSB MIA75FLD72Accident · No injuriesClosedPiper J-3 · Vero Beach, FLMay 17, 1975 · N23266 · Substantial damageNTSB NYC75FNE36Accident · No injuriesClosedTaylorcraft BC-65 · Fitchburg, MAMay 11, 1975 · N36195 · Substantial damageNTSB MKC75FCD44Accident · No injuriesClosedPiper J3C-65 · Clarinda, IAMay 11, 1975 · N42670 · Substantial damageNTSB IAD75DKW15Accident · No injuriesClosedTaylorcraft BC12-D · Pikeville, TNMay 11, 1975 · N44050 · Substantial damageNTSB CHI75DEM39Accident · No injuriesClosedLuscombe 8A · Marquette, MIMay 11, 1975 · N1117B · Substantial damageNTSB CHI75AC086Accident · No injuriesClosedTaylorcraft DCO-65 · Janesville, WIMay 10, 1975 · N91032 · 2 aircraft · Substantial damageNTSB NYC75DNC31Accident · No injuriesClosedTaylorcraft BC12-D · Montpelier, VTMay 5, 1975 · N5210M · 2 aircraft · Substantial damageNTSB IAD75FLJ25Accident · No injuriesClosedTaylorcraft BC12-D · Louisburg, NCMay 4, 1975 · N44215 · Substantial damageNTSB DEN75FTE63Accident · No injuriesClosedAeronca 7AC · Ft.Collins, COMay 3, 1975 · N84555 · Substantial damageNTSB CHI75DEE57Accident · No injuriesClosedPiper J3C-65 · Bradford, ILApr 26, 1975 · N6264H · Substantial damageNTSB FTW75FRJ28Accident · Minor injuriesClosedChampion 7AC · San Augustine, TXApr 3, 1975 · N84178 · Substantial damageNTSB FTW75DRJ26Accident · No injuriesClosedPiper J3C-65 · Texarkana, ARMar 30, 1975 · N24962 · Substantial damageNTSB CHI75DEM32Accident · No injuriesClosedAeronca 11AC · Ontonagon, MIMar 19, 1975 · N85931 · Substantial damageNTSB NYC75FFA31Accident · Minor injuriesClosedLuscombe 8A · Duanesburg, NYMar 15, 1975 · N71790 · Substantial damageNTSB CHI75DEP48Accident · No injuriesClosedLuscombe 8A · Hales Corners, WIMar 13, 1975 · N2704K · Substantial damageNTSB ANC75DAG78Accident · No injuriesClosedPiper J-3 · Talkeetna, AKMar 12, 1975 · N7007H · Substantial damageNTSB OAK75FJA09Accident · Serious injuriesClosedPiper J3C-65 · Honolulu, HIMar 8, 1975 · N62053 · No damageNTSB FTW75DPD30Accident · No injuriesClosedAeronca 7AC · Denton, TXMar 6, 1975 · N2121E · Substantial damageNTSB CHI75DCA05Accident · No injuriesClosedAeronca 7AC · Freeburg, ILFeb 19, 1975 · N81611 · Substantial damageNTSB FTW75FPG34Accident · No injuriesClosedAeronca 7AC · Lake City, ARFeb 15, 1975 · N84610 · Substantial damageNTSB FTW75FPD25Accident · No injuriesClosedPiper J3C-65 · Santos, TXJan 26, 1975 · N38365 · Substantial damageNTSB IAD75FKM17Accident · No injuriesClosedPiper J4 · Advance, NCJan 22, 1975 · N26903 · Substantial damageNTSB MIA75FKT42Accident · Serious injuriesClosedAeronca 7AC · Belle Glade, FLJan 2, 1975 · N84543 · Substantial damageNTSB CHI75FEP37Accident · No injuriesClosedAeronca 11AC · Waupaca, WIJan 2, 1975 · N9428E · Substantial damageNTSB NYC75FNE24Accident · Minor injuriesClosedAeronca 7AC · Turner Falls, MADec 31, 1974 · N85191 · Substantial damage
Back to Continental A&C65 series