Final NTSB investigations: Aeronca 65-LB
10 cases on aircraft the registry lists as Aeronca 65-LB. 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 |
|---|---|
| 1969 | 2 |
| 1970 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2018 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190932'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190932'))
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 GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB BFO95LA065Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Grand River, OHThe pilot selected unsuitable terrain for the takeoff.NTSB MIA91LA191Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Hilliard, FLFailure of the pilot to maintain a proper glidepath during final approach resulting in the inflight collision with trees then the ground.NTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.NTSB NYC83LA139Accident · Minor injuriesLimited investigationFinal reportAeronca 65-LB · Auburn, NYAccording to the plt, he was en route when the eng lost power. He maneuvered for a forced landing in a nearby hay/corn field. During the flare, the eng regained power momentarily & lifted about 50 ft. at about the same time, the acft encountered wind gusts,…NTSB ATL81FIG03Accident · Serious injuriesClosedAeronca 65L · Pasadena, MDNTSB LAX70DUG53Accident · No injuriesClosedAeronca 65-LB · Daggett, CANTSB DIA69F0209Accident · No injuriesClosedAeronca 65-LB · Wh Sul Sprgs, WVNTSB MKC69D0433Accident · No injuriesClosedAeronca LB-65 · Wh.Bear Lake, MNNTSB MIA67F0261Accident · Minor injuriesClosedAeronca 65-LB · St-Stephens, SC