NTSB investigations: Aeronca 11AC, NY
19 cases on aircraft the registry lists as Aeronca 11AC. 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
| 1964 | 3 |
|---|---|
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2024 | 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\" = '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 ('0191102'))
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 ('0191102'))
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 ERA24LA238Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Geneseo, NYThe pilot’s failure to maintain directional control during the takeoff roll resulting in a runway excursion, and subsequent nose over.NTSB ERA13LA221Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Hoosick Falls, NYThe failure of the left wing attachment bracket weld due to inadequate welding by unknown maintenance personnel.NTSB ERA11CA163Accident · No injuriesData collectionFinal reportAeronca 11AC · Randolph, NYThe certified flight instructor's delayed response to the student pilot's loss of directional control during takeoff, which resulted in a runway excursion and collision with a building.NTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.NTSB NYC94LA152Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Schuylerville, NYthe pilots failure to maintain adequate airspeed, which resulted in a stall/mush.NTSB NYC83IA040Incident · No injuriesIncident investigationFinal reportAeronca 11AC · Monticello, NYAs the flight made a three point landing in strong, gusting, left crosswinds, a gust of wind lifted the aircraft's left wing. Directional control was lost and the aircraft departed the right side of the runway. It came to rest at the bottom of a grassy slope…NTSB NYC79FHM14Accident · No injuriesClosedAeronca 11AC · Newburgh, NYNTSB NYC79FFJ03Accident · Minor injuriesClosedAeronca 11AC · Collins, NYNTSB NYC75FHJ26Accident · No injuriesClosedAeronca 11AC · Amityville, NYNTSB NYC72FFA44Accident · Minor injuriesClosedAeronca 11AC · Broadalbin, NYNTSB NYC71DFA65Accident · No injuriesClosedAeronca 11AC · Richfield Sprg, NYNTSB NYC71FHJ14Accident · Minor injuriesClosedAeronca 11AC · East Moriches, NYNTSB NYC70FHJ06Accident · No injuriesClosedAeronca 11AC · Flushing, NYNTSB NYC69D0142Accident · No injuriesClosedAeronca 11AC · Clifton Sprgs, NYNTSB NYC69D0080Accident · No injuriesClosedAeronca 11AC · Memphis, NYNTSB NYC68F0248Accident · No injuriesClosedAeronca 11AC · Amityville, NYNTSB UNK65X1010Accident · No injuriesClosedAeronca 11AC · Spring Valley, NYNTSB UNK65X0310Accident · 1 fatalClosedAeronca 11AC · Spencerport, NYNTSB UNK64X0358Accident · Serious injuriesClosedAeronca 11AC · Bayport, NY