Skip to content

Lycoming VO-435-A1F

NTSB investigations · 20

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 ('42200') 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 ('42200')
  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 ('42200')
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 ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.Aug 18, 2021 · N777TC · Substantial damage NTSB CEN16LA161Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Los Fresnos, TXThe pilot's inability to see and avoid the power lines because of trees obscuring his view.Apr 21, 2016 · N64702 · Destroyed NTSB CEN12LA480Accident · Minor injuriesLimited investigationFinal reportScotts-Bell 47 47G-2A · Akeley, MNThe pilot’s failure to maintain helicopter control during low altitude agricultural operations.Jul 25, 2012 · N73252 · Substantial damage NTSB CEN12LA120Accident · Serious injuriesLimited investigationFinal reportContinental Copters 47G2 · Lohn, TXThe improper installation of the tail rotor gearbox by maintenance personnel, which led to accelerated wear of the ring and pinion gears, resulting in the loss of tail rotor effectiveness and subsequent forced landing.Jan 1, 2012 · N9021R · Substantial damage NTSB LAX99LA047Accident · No injuriesLimited investigationFinal reportBell 47G2 · Helendale, CAThe pilot's failure to follow proper procedures to recover from main rotor blade aerodynamic retreating blade stall.Dec 12, 1998 · N9021R · Substantial damage NTSB MIA98LA197Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M47A · Citronelle, ALThe pilot's failure to control the helicopter's altitude while overflying an area of rising terrain and trees.Jul 15, 1998 · N1001F · Substantial damage NTSB LAX97LA285Accident · No injuriesLimited investigationFinal reportBell 47G2 · Mojave, CAThe student's improper use of the throttle and collective controls and the flight instructor's inadequate supervision of the flight.Aug 12, 1997 · N9021R · Substantial damage NTSB MIA91LA141Accident · No injuriesLimited investigationFinal reportBell 47-G · Aguadilla, PRThe improper in flight planning/decision of the pilot-in-command to conduct an out-of-ground-effect hover with a right crosswind. This resulted in an in flight loss of control due to settling with power and in flight collision with terrain.May 11, 1991 · N955B · Destroyed NTSB MIA89LA229Accident · No injuriesLimited investigationFinal reportBell 47G · Ponce, PRFailure of the aft tail rotor drive shaft.Aug 23, 1989 · N955B · Substantial damage NTSB LAX86LA283Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M · Valencia, CAThe pilot reported that he heard a loud bang and grinding noise from the engine/main transmission area while on a swath run. He stated that the main rotor RPM decayed immediately after he heard the noise. As the helicopter descended to about 50 feet above the…Jul 6, 1986 · N51856 · Substantial damage NTSB ATL81DKW21Accident · No injuriesClosedTexas Hel M-47A · Rickman, TNJul 29, 1981 · N1001F · Substantial damage NTSB LAX81DUQ26Accident · No injuriesClosedTexas Hel M74A · Rosamond, CAJul 3, 1981 · N51856 · Substantial damage NTSB ANC80FA015Accident · 1 fatalClosedBell 47G3B1 · Farewell, AKNov 24, 1979 · N73249 · Substantial damage NTSB MIA78FKQ12Accident · No injuriesClosedBell 47G3B · Red Lick, MSMay 28, 1978 · N73249 · Destroyed NTSB NYC75FHJ28Accident · Serious injuriesClosedBell 47G-2A · New York, NYFeb 27, 1975 · N73252 · Destroyed NTSB SEA74DYG07Accident · No injuriesClosedBell 47G3B · Orofino, IDAug 1, 1973 · N73249 · Substantial damage NTSB NYC72FHJ01Accident · No injuriesClosedBell-Cci 47G2 · Amityville, NYJul 11, 1971 · N9021R · Substantial damage NTSB MKC70F0132Accident · No injuriesClosedBell 47G3B1 · Hemingford, NEAug 4, 1969 · N73249 · Substantial damage NTSB DEN66A0018Accident · Serious injuriesClosedBell 47G3B · Durango, COSep 1, 1965 · N73249 · Substantial damage NTSB UNK64X1853Accident · No injuriesClosedBell 47G3B · Sheridan, WYMay 19, 1964 · N73249 · Substantial damage

Back to Lycoming VO-435-A1F