Skip to content

NTSB investigations: Aeronca 7AC, NY

42 cases on aircraft the registry lists as Aeronca 7AC. 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 per year

19642026

Where

Latest cases

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."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102')) 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.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102'))
  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."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102'))
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 ERA18FA141Accident · 1 fatalField investigationFinal reportAeronca 7AC · Middletown, NYThe pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover.May 5, 2018 · N84396 · Substantial damage NTSB ERA15LA251Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · East Moriches, NYThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a collision with a tree.Jun 24, 2015 · N84927 · Substantial damage NTSB NYC07CA115Accident · No injuriesData collectionFinal reportAeronca 7AC · Lagrangeville, NYThe pilot's failure to identify a partially buried rock in the landing surface of an unimproved grass runway, which resulted in an inadvertent collision during the landing roll.May 4, 2007 · N1478E · Substantial damage NTSB NYC00LA091Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Pawling, NYLoss of engine power for undetermined reasons.Mar 7, 2000 · N474HH · Substantial damage NTSB NYC90LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Blossvale, NYFailure of the pilot to maintain directional control during landing. Factors related to the accident were: a gusty quartering tailwind.Apr 19, 1990 · N2275E · Substantial damage NTSB CHI88FA206Accident · 1 fatalField investigationFinal reportAeronca 7CCM · Barker, NYThe pilot in command failed to maintain control of the airplane.Aug 15, 1988 · N83255 · Destroyed NTSB NYC87LA195Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Jamestown, NYThe student plt rented the acft & flew to a field aprx 40 mi from the dep arpt. After landing, a passenger boarded the acft. The student started to takeoff again. Drg takeoff, the acft lifted off, but would not climb sufficiently to clear trees at the dep end…Jul 3, 1987 · N2460E · Substantial damage NTSB NYC86FA182Accident · 1 fatalField investigationFinal reportAeronca 7AC · Durhamville, NYAircraft departed rwy 35 at kamp airport, climbed to about 200 feet, turned right, stalled and crashed vertically into the ground. A witness said that the aircraft climbed, the engine sputtered, and then stopped. No preimpact malfunction/failure was…Jul 11, 1986 · N84854 · Destroyed NTSB NYC86FA140Accident · 2 fatalField investigationFinal reportAeronca 7AC · Chaumont, NYThe pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant.Jun 5, 1986 · N82079 · Destroyed NTSB NYC81FFJ25Accident · Serious injuriesClosedAeronca 7AC · Honeoye Falls, NYSep 17, 1981 · N84947 · Substantial damage NTSB NYC80DA090Accident · Serious injuriesClosedAeronca 7AC · Aurora, NYSep 21, 1980 · N2610E · Substantial damage NTSB NYC79DFA31Accident · No injuriesClosedAeronca 7AC · Deryter, NYJul 7, 1979 · N83152 · Substantial damage NTSB NYC79FHM20Accident · Minor injuriesClosedAeronca 7AC · Stormville, NYJun 7, 1979 · N3281E · Destroyed NTSB NYC77DFA31Accident · No injuriesClosedAeronca 7AC · Johnstown, NYJul 10, 1977 · N1488E · Substantial damage NTSB NYC76FFJ08Accident · Serious injuriesClosedAeronca 7AC · Albion, NYSep 24, 1975 · N84592 · Destroyed NTSB NYC75DFA45Accident · No injuriesClosedAeronca 7AC · Oneonta, NYJun 27, 1975 · N85227 · Substantial damage NTSB NYC75DFA40Accident · No injuriesClosedAeronca 7AC · Massena, NYJun 8, 1975 · N85684 · Substantial damage NTSB NYC75FFJ15Accident · Minor injuriesClosedAeronca 7AC · W Bloomfield, NYNov 3, 1974 · N81590 · Substantial damage NTSB NYC74DHJ14Accident · No injuriesClosedAeronca 7AC · Deer Park, NYOct 8, 1973 · N84624 · Substantial damage NTSB NYC73DFA22Accident · No injuriesClosedAeronca 7AC · Plattsburgh, NYNov 1, 1972 · N1486E · Substantial damage NTSB NYC72DFJ33Accident · Serious injuriesClosedAeronca 7AC · North Collins, NYApr 15, 1972 · N85019 · Substantial damage NTSB NYC72FHJ17Accident · No injuriesClosedAeronca 7AC · Amityville, NYMar 11, 1972 · N2122E · Substantial damage NTSB NYC71AN075Accident · 1 fatalClosedAeronca 7AC · Watertown, NYJan 3, 1971 · N1271E · Substantial damage NTSB NYC70D0095Accident · No injuriesClosedAeronca 7AC · Duanesburgh, NYAug 17, 1969 · N84771 · Substantial damage NTSB NYC70F0085Accident · Serious injuriesClosedAeronca 7AC · Oxford, NYAug 11, 1969 · N3454E · Substantial damage NTSB NYC68D0453Accident · No injuriesClosedAeronca 7AC · Amityville, NYApr 11, 1968 · N82998 · Substantial damage NTSB NYC68F0170Accident · No injuriesClosedAeronca 7AC · Amityville, NYOct 5, 1967 · N1119E · Substantial damage NTSB NYC68D0142Accident · No injuriesClosedAeronca S7AC · Niagra Falls, NYJun 28, 1967 · N82423 · Destroyed NTSB NYC67D0603Accident · No injuriesClosedAeronca 7AC · Weedsport, NYMar 4, 1967 · N83408 · Substantial damage NTSB NYC67F0045Accident · No injuriesClosedAeronca 7AC · Hartland, NYJul 4, 1966 · N2550E · Substantial damage NTSB NYC66D0279Accident · No injuriesClosedChampion 7AC · Jordanville, NYSep 26, 1965 · N85294 · Substantial damage NTSB NYC66D0120Accident · Minor injuriesClosedAeronca 7AC · Lakeport, NYJul 15, 1965 · N2481E · Substantial damage NTSB NYC66F0102Accident · No injuriesClosedCessna 140 · Cambridge, NYJun 6, 1965 · N76065 · 2 aircraft · Substantial damage NTSB NYC65F0048Accident · No injuriesClosedAeronca 7AC · Shirley, NYFeb 21, 1965 · N83486 · Substantial damage NTSB NYC65F0026Accident · No injuriesClosedAeronca 7AC · Lindenhurst, NYJan 25, 1965 · N4428E · Substantial damage NTSB UNK65X0499Accident · No injuriesClosedAeronca 7AC · Hamlin, NYOct 31, 1964 · N85555 · Substantial damage NTSB UNK64X3958Accident · No injuriesClosedAeronca 7AC · Springville, NYSep 13, 1964 · N2992E · Substantial damage NTSB UNK64X3535Accident · Minor injuriesClosedAeronca 7AC · Guilderland, NYAug 22, 1964 · N2214E · Substantial damage NTSB UNK64X3105Accident · No injuriesClosedAeronca 7AC · E Moriches, NYJul 29, 1964 · N3754E · Substantial damage NTSB UNK64X2411Accident · Minor injuriesClosedAeronca 7AC · Red Hook, NYJun 21, 1964 · N82546 · Substantial damage NTSB UNK64X1721Accident · No injuriesClosedAeronca 7AC · Wallkill, NYMay 11, 1964 · N82143 · Substantial damage NTSB UNK64X1515Accident · 2 fatalClosedAeronca 7AC · Green Ridge, NYApr 29, 1964 · N1384E · Destroyed