Skip to content

NTSB investigations: Aeronca 7AC, AR

21 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · DeWitt, ARThe pilot’s loss of airplane directional control while landing.Nov 22, 2023 · N84692 · Substantial damage NTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.Apr 8, 2001 · N2129E · Substantial damage NTSB FTW00LA247Accident · Minor injuriesLimited investigationFinal reportAeronca BL7-AC · Hot Springs, ARThe pilot's failure to maintain control during landing. A factor was the wind gusts.Sep 1, 2000 · N83866 · Substantial damage NTSB FTW98LA233Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sheridan, ARThe inadvertent engine start due to the pilot's failure to ensure that the magneto switch was in the OFF position when he was attempting to clear the flooded engine. A factor was the pilot's improper starting procedure, which resulted in flooding the engine.May 20, 1998 · N3504E · Substantial damage NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…Aug 30, 1988 · N85294 · Substantial damage NTSB MKC86LA067Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Jacksonville, ARThe pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As…Mar 10, 1986 · N82202 · Substantial damage NTSB MKC85LA004Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Carlisle, ARThe acft collided with a piece of farm equipment during a force landing following engine failure. Investigation revealed that the plt was flying the acft to hazen, AR, to show it to his father when the engine failed. Examination of the wreckage failed to…Oct 8, 1984 · N84654 · Substantial damage NTSB FTW82FPG14Accident · 2 fatalFinal reportAeronca 7AC · Lehi, ARThe acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…Jun 7, 1982 · N83654 · Substantial damage NTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARSep 22, 1977 · N2358E · Destroyed NTSB FTW77FPG58Accident · Serious injuriesClosedAeronca 7AC · Almond, ARJul 6, 1977 · N85695 · Substantial damage NTSB FTW76DPG91Accident · No injuriesClosedAeronca 7AC · Searcy, ARJul 24, 1976 · N82739 · Substantial damage NTSB FTW75FPG34Accident · No injuriesClosedAeronca 7AC · Lake City, ARFeb 15, 1975 · N84610 · Substantial damage NTSB FTW75FPG33Accident · Serious injuriesClosedAeronca 7AC · Coy, ARFeb 11, 1975 · N85238 · Substantial damage NTSB FTW75AF003Accident · 2 fatalClosedAeronca 7AC · Stuttgart, ARJul 22, 1974 · N82372 · Destroyed NTSB FTW74FPG62Accident · Minor injuriesClosedAeronca 7AC · Lake City, ARMay 19, 1974 · N2998E · Destroyed NTSB FTW74DPG49Accident · No injuriesClosedAeronca 7AC · Paragould, ARMar 14, 1974 · N83147 · Substantial damage NTSB FTW70DPG23Accident · No injuriesClosedAeronca 7AC · Marshall, ARMay 1, 1970 · N82170 · Substantial damage NTSB FTW70F0236Accident · Serious injuriesClosedAeronca 7AC · Menifee, ARSep 20, 1969 · N2607E · Substantial damage NTSB FTW67F0213Accident · No injuriesClosedAeronca 7AC · Gurdon, ARSep 8, 1966 · N85695 · Substantial damage NTSB UNK64X3533Accident · No injuriesClosedAeronca 7AC · Fayetteville, ARAug 22, 1964 · N81560 · Substantial damage NTSB UNK64X3448Accident · Serious injuriesClosedAeronca 7AC · Mcdougal, ARAug 18, 1964 · N83306 · Destroyed