NTSB investigations: Aeronca 7AC, NJ
15 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.
Cases per year
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1976 | 2 |
| 1983 | 1 |
| 1995 | 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.\"eventStateOrRegion\" = 'NJ' 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" = 'NJ' 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" 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 NYC95LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Andover, NJThe flight instructor's inadequate preflight which failed to detect an inadequate fuel supply which subsequently resulted in fuel exhaustion and the loss of engine power.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 NYC76DHD41Accident · No injuriesClosedAeronca 7AC · Smithville, NJNTSB NYC76FHD26Accident · No injuriesClosedAeronca 7AC · Smithville, NJNTSB NYC72DHD37Accident · No injuriesClosedAeronca 7AC · Medford, NJNTSB NYC71FHD47Accident · Minor injuriesClosedChampion 7AC · Bargaintown, NJNTSB NYC70DHD19Accident · No injuriesClosedAeronca 7AC · Ocean City, NJNTSB NYC70D0149Accident · No injuriesClosedChampion 7AC · Salem, NJNTSB NYC70F0086Accident · Minor injuriesClosedAeronca 7AC · Moorestown, NJNTSB NYC69A0102Accident · 1 fatalClosedAeronca 7AC · Landing, NJNTSB NYC69D0139Accident · Minor injuriesClosedAeronca 7AC · Whitehouse, NJNTSB NYC68D0285Accident · No injuriesClosedAeronca 7AC · Millville, NJNTSB NYC67D0338Accident · No injuriesClosedAeronca 7AC · Asbury Park, NJNTSB NYC66F0413Accident · Minor injuriesClosedAeronca 7AC · Fort Lee, NJNTSB NYC66A0011Accident · 2 fatalClosedAeronca 7AC · Ford, NJ