Franklin 6A4200 series
NTSB investigations · 39
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 ('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_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 ('27027')
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 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.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.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.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.NTSB LAX93LA010Accident · No injuriesLimited investigationFinal reportBell 47-D1 · El Monte, CAThe pilot's failure to maintain the rotor RPM.NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.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…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.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…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…NTSB LAX81FUJ12Accident · Minor injuriesClosedBell 47D-1 · Horseshoe Lk, AZNTSB MIA81FKJ03Accident · No injuriesClosedBell 47D1 · Panama City, FLNTSB NYC80FGT16Accident · No injuriesClosedBell 47G · Gettysburg, PANTSB CHI79DEM02Accident · No injuriesClosedBell 47G · Saginaw, MINTSB CHI77FEM43Accident · No injuriesClosedHiller UH-12B · Carrollton, MINTSB CHI77FEK01Accident · No injuriesClosedBell 47D1 · Johnstown, OHNTSB OAK76DVD44Accident · Minor injuriesClosedBell 47G · Pittsburg, CANTSB OAK76DVG16Accident · No injuriesClosedBell 47G · Gold Run, CANTSB MIA76FLG07Accident · No injuriesClosedBell 47G · Pinewood, SCNTSB FTW75FPD33Accident · No injuriesClosedBell 47K · Arlington, TXNTSB SEA75DYI01Accident · No injuriesClosedBell 47G · Midland, ORNTSB NYC74FHA06Accident · No injuriesClosedBell 47D1 · Stockertown, PANTSB FTW74DRA03Accident · Minor injuriesClosedBell 47D1 · Sealey, TXNTSB MKC72FCA30Accident · Serious injuriesClosedBell 47D1 · Dorena, MONTSB NYC72FID13Accident · 1 fatalClosedBell 47D-1 · Millers Tavern, VANTSB MIA72FLG05Accident · No injuriesClosedBell 47G · Sumter, SCNTSB FTW71FRA65Accident · No injuriesClosedBell 47D1 · Alvin, TXNTSB LAX70F0142Accident · Serious injuriesClosedBell 47-H · Laguna Bch, CANTSB FTW70F0022Accident · 1 fatalClosedBell 47D1 · Livingston, LANTSB FTW69F0392Accident · No injuriesClosedBell 47D1 · Denton, TXNTSB DIA68A0012Accident · No injuriesClosedBell 47D1 · Currituck, NCNTSB SEA67A0032Accident · No injuriesClosedBell 47D1 · Llensburg, WANTSB MIA66A0027Accident · No injuriesClosedBell 47D1 · Sligo, NCNTSB MKC66A0006Accident · No injuriesClosedBell 47D-1 · Wichita, KSNTSB MIA66A0008Accident · No injuriesClosedBell Tomcat · Skene, MSNTSB UNK65X0522Accident · No injuriesClosedBell 47H1 · Lagunabeach, CANTSB UNK64X3405Accident · 1 fatalClosedBell 47G · Alameda, CANTSB UNK64X3311Accident · No injuriesClosedBell 47D1 · Rose Hill, KSNTSB UNK64X1530Accident · Minor injuriesClosedCont Copter 47G · Windsor, MO
Back to Franklin 6A4200 series