Skip to content

Franklin 2A4 series

NTSB investigations · 19

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.engine_model_code IN ('27001') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.engine_model_code IN ('27001')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('27001')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.May 14, 2026 · N9158L · Substantial damage NTSB CEN23LA101Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7ACA · Bayport, MNThe pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.Feb 4, 2023 · N9111L · Substantial damage NTSB ERA17LA282Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Fairhope, ALA total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.Aug 18, 2017 · N9176L · Substantial damage NTSB FTW94FA299Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Lakeside, TXThe pilot's failure to maintain minimum required airspeed for flight. A factor was the loss of engine power for undetermined reasons.Sep 18, 1994 · N68529 · Substantial damage NTSB SEA92LA220Accident · No injuriesLimited investigationFinal reportBellanca 7ACA · Rosalia, WAFailure of the tailwheel spring bracket. A factor to the accident was: directional control was not maintained.May 30, 1992 · N9159L · Substantial damage NTSB ANC90FA042Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Wasilla, AKThe failure of the PIC to maintain sufficient airspeed to preclude a stall.Mar 24, 1990 · N68596 · Substantial damage NTSB FTW87FA210Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Graford, TXThe pilot departed possum kingdom airport and entered a crosswind turn. The pilot heard a loud 'pop' and could not move the aileron control to recover from the turn. The aircraft entered an uncontrolled descent and crashed into a lake. The aileron pulley for…Sep 5, 1987 · N68529 · Substantial damage NTSB LAX86LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Lompoc, CAThe bellance champion went out of control an collided with two other parked acft after a hand propped start. The plt indicated that the acft was tied down with two chains attached to each of the wings at one end and to a cable that stretched across the ramp…May 21, 1986 · N9158L · Substantial damage NTSB NYC79DFA01Accident · Minor injuriesClosedBellanca 7ACA · Tupper Lake, NYOct 16, 1978 · N9176L · Substantial damage NTSB LAX77DUQ08Accident · No injuriesClosedChampion 7ACA · Pacoima, CANov 13, 1976 · N62965 · Substantial damage NTSB NYC76DHA08Accident · Minor injuriesClosedBellanca 7AC · Zieglerville, PAAug 20, 1975 · N9162L · Substantial damage NTSB SEA75DYE38Accident · Minor injuriesClosedChampion 7ACA · Puyallup, WAApr 4, 1975 · N10986 · Destroyed NTSB MIA75DKT70Accident · No injuriesClosedBellanca 7ACA · Delray Beach, FLMar 30, 1975 · N9189L · Substantial damage NTSB MKC75DTK14Accident · No injuriesClosedBellanca 7ACA · Madison, SDMar 4, 1975 · N9156L · Substantial damage NTSB OAK75DVG38Accident · No injuriesClosedChampion 7AC · Manton, CANov 30, 1974 · N4995 · Substantial damage NTSB FTW74FPA27Accident · No injuriesClosedBellanca 7ACA · Plano, TXJun 7, 1974 · N9161L · Substantial damage NTSB CHI74AC083Accident · 1 fatalClosedBellanca 7ACA · Rhinelander, WIApr 9, 1974 · N68530 · Substantial damage NTSB NYC74FHM10Accident · Minor injuriesClosedBellanca 7ACA · Hanover, NJNov 7, 1973 · N62965 · Substantial damage NTSB MKC72DCG37Accident · No injuriesClosedBellanca 7ACA · Smithville, MOFeb 21, 1972 · N9157L · Substantial damage

Back to Franklin 2A4 series