Franklin 4AC199D&E series
NTSB investigations · 35
Matched to the registry by N-number and event date, newest first.
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_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 ('27009')
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 ('27009')
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 CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.NTSB CEN09CA322Accident · No injuriesData collectionFinal reportStinson 10A · Pickwick, MNThe loss of engine power for undetermined reasons.NTSB DEN06CA031Accident · Minor injuriesData collectionFinal reportCulver Cadet LCA · Alamogordo, NMthe pilot's failure to maintain aircraft control during the departure climb. Contributing factors included the gusty winds and the downdraft.NTSB CHI05CA108Accident · No injuriesData collectionFinal reportInterstate S-1A-90F · Lancaster, KSA loss of engine power due to fuel exhaustion as a result of a fuel leak. Contributing factors were the pilot's inadequate preflight/planning preparation and the unsuitable terrain encountered, the tree and the fence.NTSB SEA05FA072Accident · 2 fatalField investigationFinal reportStinson 10-A · Oak Harbor, WAThe pilot's failure to adequately plan the approach for landing and maintain clearance from trees during the go-around. A tailwind and trees were factors.NTSB LAX00LA348Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Ione, CAThe failure of the right brake during the landing roll resulting in loss of directional control and subsequent nose over of the airplane.NTSB DEN00LA100Accident · No injuriesLimited investigationFinal reportCulver LFA · Moab, UTOverheating of the left brake, causing the wheel to lock. Factors were the pilot not being able to maintain directional control, a dirt berm, and a drainage ditch.NTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.NTSB ATL90DMG01Accident · 1 fatalFinal reportWaldron Flybaby · Troy, NCPoor judgement of the non-rated pilot, due to impairment from consumption of alcohol, his lack of training/qualification, his improper use of the engine controls which resulted in loss of engine power from probable carburetor ice, and his failure to maintain…NTSB MKC84FA202Accident · 1 fatalField investigationFinal reportCulver LFA · Plattsburg, MOWitnesses viewed the acft in a nose high attitude at a low alt near the south end of rwy 18. The acft climbed a short distance, rolled to the left and descended nearly vertically to the ground.NTSB MIA83LA107Accident · No injuriesLimited investigationFinal reportStinson 10A · Miami, FLThe owner of the acft said that the plt was negotiating to buy the acft but conducted this flt without proper authority in the acft that was not airworthy. The plt had landed the acft earlier in an emergency situation declaring a loss of oil pressure and RPM.…NTSB MIA83LA097Accident · No injuriesLimited investigationFinal reportStinson 10A · Defuniak Spring, FLThe engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there…NTSB FTW82DA309Accident · No injuriesFinal reportStinson 10A · Los Lumas, NMWhile landing, the plane touched down in a crosswind from the right at 15 knots. The pilot reported that the plane weathercocked to the right and went into a ditch. Reportedly, the pilot was unable to control the heading of the aircraft in the crosswind.NTSB SEA80FYM26Accident · No injuriesClosedStinson 10A · Pacific City, ORNTSB NYC78FNC24Accident · No injuriesClosedStinson 10A · Ossipee, NHNTSB LAX77FUK04Accident · Minor injuriesClosedStinson 10A · Tucson, AZNTSB MIA77FLD63Accident · Minor injuriesClosedBaby GR LKS BGL B1 · Lakeland, FLNTSB MIA75DKJ33Accident · No injuriesClosedStinson 10A · Cullman, ALNTSB IAD75DKM14Accident · 1 fatalClosedBaby Ace E · Asheville, NCNTSB LAX74FUG07Accident · No injuriesClosedCulver LCA · Corona, CANTSB OAK73FVG11Accident · Serious injuriesClosedAeronca 7AC · Rio Linda, CANTSB MKC73DCD08Accident · No injuriesClosedStinson 10A · Kiron, IANTSB MKC72DCD73Accident · Minor injuriesClosedStinson 10A · Troy Mills, IANTSB NYC71FGT13Accident · Minor injuriesClosedStinson 10-A · Hallam, PANTSB MIA71DKT38Accident · No injuriesClosedStinson 10A · Ft Lauderdale, FLNTSB NYC71DFM03Accident · No injuriesClosedCulver LFA · Ansonia, CTNTSB FTW70F0047Accident · No injuriesClosedStinson 10A · Mineral Wells, TXNTSB NYC69D0181Accident · Minor injuriesClosedCulver LFA · Perry, NYNTSB SEA68D0280Accident · No injuriesClosedCulver LFA · Eugene, ORNTSB NYC68F0047Accident · Minor injuriesClosedStinson 10A · Shippenville, PANTSB SEA67D0346Accident · No injuriesClosedStinson 10A · Inehelium, WANTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORNTSB CHI67D0212Accident · No injuriesClosedStinson 10A · Rockton, ILNTSB NYC67D0007Accident · No injuriesClosedStinson 10A · Penn Yan, NYNTSB MIA65F0033Accident · No injuriesClosedStinson 10A · Greenville, SC
Back to Franklin 4AC199D&E series