NTSB investigations: Aeronca 7AC
9 cases on aircraft the registry lists as Aeronca 7AC, where the first occurrence was “In flight collision with terrain/water”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2005 | 1 |
Where
Open the mapLatest cases
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_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.aircraft_model_code IN ('2110102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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.aircraft_model_code IN ('2110102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 CHI05LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Wautoma, WIThe inadvertent stall and low airspeed by the pilot-in-command while maneuvering. Additional causes were the low altitude when the stall occurred and excessive takeoff weight by the pilot-in-command.NTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.NTSB SEA95FA072Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brush Prairie, WAUndetermined.NTSB FTW87LA215Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Batesvile, TXA witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine…NTSB LAX85LA338Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAOn aug 4, 1985 an Aeronca 7AC collided with the ground while buzzing over a sand bar near Santa Paula, CA. VMC existed at the time. The ac sustained substantial damage and the pvt plt received minor injuries. He reported no mechanical problems with the ac…NTSB SEA84LA117Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Ketchikan, AKThe plt was making a low turn at slow airspeed to land on a gravel road. His left gear dug into the gravel and broke offand the acft ground looped.NTSB ATL83LA217Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Shinnston, WVThe instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a…NTSB NYC83LA064Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Pittstown, NJThere were 2-3 ft snowbanks on the sides of the rwy. At the end of the landing roll the left wheel caught the edge of a snowbank causing the acft to swing into the snowbank & tip over.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…