NTSB investigations: Aeronca C-3
8 cases on aircraft the registry lists as Aeronca C-3. 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
| 1966 | 1 |
|---|---|
| 1977 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2002 | 1 |
| 2005 | 2 |
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 ('0190302'))
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 ('0190302'))
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 ATL05CA122Accident · Serious injuriesData collectionFinal reportAeronca C3 · Summerville, SCThe maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.NTSB IAD05LA076Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Toughkenamon, PAThe failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.NTSB LAX02LA100Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Sonoma, CAthe pilot's excessive remedial control inputs in response to a passenger's control inputs, which led to a failure to maintain an adequate airspeed and an inadvertent stall/mush. The pilot's inadequate preflight decision to allow a student pilot to occupy the…NTSB ATL83LA203Accident · Serious injuriesLimited investigationFinal reportAeronca C3 · Ocean City, MDAt about 150 ft AGL after takeoff the acft stalled. The plt previously had an accident with the acft on 6/13/82. Since that date he had recorded 17 hrs of flt time with less than 1 hr in a J-3 cub. The J-3 is similar to the Aeronca C3 in size but with twice…NTSB ATL82FIG08Accident · Serious injuriesFinal reportAeronca C-3 · Ocean City, MDThe aircraft was observed taking off on runway 14 under a 700 ft ceiling. It climbed to about 100 ft AGL, and while still over the runway, it began a left turn and started losing altitude. The pilot reported that during the takeoff, he had throttled back and…NTSB CHI80DA061Accident · 1 fatalClosedAeronca C-3 · Luray, INNTSB MIA77FA055Accident · 1 fatalClosedAeronca C3 · Immokalee, FLNTSB MIA66F0513Accident · Minor injuriesClosedAeronca C-3 · Hope Mills, NC