Skip to content

NTSB investigations: Franklin 6A4200 series

39 cases on aircraft whose registry engine model is Franklin 6A4200 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

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_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.engine_model_code IN ('27027')) 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_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.engine_model_code IN ('27027'))
  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.engine_model_code IN ('27027'))
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 CEN12LA650Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Rio Vista, TXThe catastrophic failure and disintegration of the No. 6 engine piston, which resulted in a total loss of engine power.Sep 19, 2012 · N94735 · Substantial damage NTSB LAX06CA296Accident · No injuriesData collectionFinal reportBell 47G · Angels Camp, CAa hard landing due to the pilot's inadequate compensation for a wind shift encountered on final approach and his failure to maintain an adequate translational lift airspeed.Sep 18, 2006 · N7762 · Substantial damage NTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.Aug 17, 1998 · N2795A · Substantial damage NTSB BFO95LA084Accident · No injuriesLimited investigationFinal reportBell 47D1 · Sidney, OHthe student pilot's abrupt touchdown while landing in a field. Related factors are the student pilot's failure to attain the proper descent rate during the approach to landing, and the flight instructor's inadequate supervision of the student.Aug 22, 1995 · N9115R · Substantial damage NTSB LAX93LA010Accident · No injuriesLimited investigationFinal reportBell 47-D1 · El Monte, CAThe pilot's failure to maintain the rotor RPM.Oct 11, 1992 · N162B · Substantial damage NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.Nov 6, 1989 · N73871 · Destroyed NTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…Jul 11, 1988 · N12087 · Substantial damage NTSB LAX86LA065Accident · Serious injuriesLimited investigationFinal reportHiller H-23A · Madera, CAThe helicopter crashed during a local frost protection flight. After about one hour of light, in dark night time conditions, fog appeared suddenly and the pilot became disoriented and crashed into the ground.Dec 13, 1985 · N3107G · Destroyed NTSB ATL83LA354Accident · No injuriesLimited investigationFinal reportBell 47G · Charleston, WVThe helicopter settled after takeoff and rolled over after touching down on sloping terrain. One of the two pilots aboard was being transported to receive a private rating in helicopters. He had been endorsed for solo in the Bell 47 and had flown the Bell 47…Sep 7, 1983 · N88754 · Substantial damage NTSB ATL82DLG12Accident · No injuriesFinal reportBell-Cont 42G EL TOMCAT-MK5A · Oswego, SCThe purpose of the flight was to study cotton fields that the pilot had been assigned to spray in the near future. He stated that during a landing approach on a farm field road, a wasp landed on his left arm and started stinging. The pilot allowed the rotor…Jul 2, 1982 · N73871 · Substantial damage NTSB LAX81FUJ12Accident · Minor injuriesClosedBell 47D-1 · Horseshoe Lk, AZNov 30, 1980 · N8272E · Substantial damage NTSB MIA81FKJ03Accident · No injuriesClosedBell 47D1 · Panama City, FLNov 8, 1980 · N9115R · Substantial damage NTSB NYC80FGT16Accident · No injuriesClosedBell 47G · Gettysburg, PAJul 12, 1980 · N2795A · Substantial damage NTSB CHI79DEM02Accident · No injuriesClosedBell 47G · Saginaw, MIOct 1, 1978 · N7762 · Substantial damage NTSB CHI77FEM43Accident · No injuriesClosedHiller UH-12B · Carrollton, MISep 26, 1977 · N94735 · Destroyed NTSB CHI77FEK01Accident · No injuriesClosedBell 47D1 · Johnstown, OHOct 1, 1976 · N9115R · Substantial damage NTSB OAK76DVD44Accident · Minor injuriesClosedBell 47G · Pittsburg, CAJul 19, 1976 · N179B · Destroyed NTSB OAK76DVG16Accident · No injuriesClosedBell 47G · Gold Run, CAAug 25, 1975 · N179B · Substantial damage NTSB MIA76FLG07Accident · No injuriesClosedBell 47G · Pinewood, SCAug 12, 1975 · N73871 · Substantial damage NTSB FTW75FPD33Accident · No injuriesClosedBell 47K · Arlington, TXApr 8, 1975 · N7762 · Substantial damage NTSB SEA75DYI01Accident · No injuriesClosedBell 47G · Midland, ORJul 7, 1974 · N957B · Destroyed NTSB NYC74FHA06Accident · No injuriesClosedBell 47D1 · Stockertown, PAAug 17, 1973 · N2795A · Substantial damage NTSB FTW74DRA03Accident · Minor injuriesClosedBell 47D1 · Sealey, TXJul 13, 1973 · N9713C · Substantial damage NTSB MKC72FCA30Accident · Serious injuriesClosedBell 47D1 · Dorena, MOJun 10, 1972 · N3111G · Substantial damage NTSB NYC72FID13Accident · 1 fatalClosedBell 47D-1 · Millers Tavern, VASep 14, 1971 · N9115R · Destroyed NTSB MIA72FLG05Accident · No injuriesClosedBell 47G · Sumter, SCAug 2, 1971 · N73871 · Destroyed NTSB FTW71FRA65Accident · No injuriesClosedBell 47D1 · Alvin, TXJun 14, 1971 · N9713C · Substantial damage NTSB LAX70F0142Accident · Serious injuriesClosedBell 47-H · Laguna Bch, CAAug 30, 1969 · N1Z · Substantial damage NTSB FTW70F0022Accident · 1 fatalClosedBell 47D1 · Livingston, LAJun 24, 1969 · N3111G · Destroyed NTSB FTW69F0392Accident · No injuriesClosedBell 47D1 · Denton, TXFeb 25, 1969 · N9115R · Substantial damage NTSB DIA68A0012Accident · No injuriesClosedBell 47D1 · Currituck, NCSep 21, 1967 · N9115R · Substantial damage NTSB SEA67A0032Accident · No injuriesClosedBell 47D1 · Llensburg, WAOct 11, 1966 · N162B · Substantial damage NTSB MIA66A0027Accident · No injuriesClosedBell 47D1 · Sligo, NCSep 7, 1965 · N9115R · Substantial damage NTSB MKC66A0006Accident · No injuriesClosedBell 47D-1 · Wichita, KSJul 24, 1965 · N9713C · Destroyed NTSB MIA66A0008Accident · No injuriesClosedBell Tomcat · Skene, MSJul 12, 1965 · N73871 · Substantial damage NTSB UNK65X0522Accident · No injuriesClosedBell 47H1 · Lagunabeach, CANov 1, 1964 · N1Z · Substantial damage NTSB UNK64X3405Accident · 1 fatalClosedBell 47G · Alameda, CAAug 15, 1964 · N179B · Destroyed NTSB UNK64X3311Accident · No injuriesClosedBell 47D1 · Rose Hill, KSAug 9, 1964 · N9713C · Substantial damage NTSB UNK64X1530Accident · Minor injuriesClosedCont Copter 47G · Windsor, MOApr 30, 1964 · N73871 · Substantial damage