Skip to content

Fatal NTSB investigations: Bellanca 14-19-3

16 cases on aircraft the registry lists as Bellanca 14-19-3. 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080106', '1250012')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080106', '1250012'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080106', '1250012'))
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 CEN14FA024Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Boerne, TXA defective exhaust system that allowed carbon monoxide to enter the cabin and impair the pilot, rendering him unable to control the airplane.Oct 27, 2013 · N11RC · Destroyed NTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.Jul 30, 2005 · N8870R · Substantial damage NTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.Mar 14, 1994 · N8885R · Destroyed NTSB ATL88FA256Accident · 2 fatalField investigationFinal reportBellanca 14-19-3 · Oak Grove, ALSep 28, 1988 · N7637E · Destroyed NTSB CHI87FA054Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · West Chicago, ILAt 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx…Dec 22, 1986 · N1253R · Destroyed NTSB DEN85FA009Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Pinehill, NMLeft wing failed inflight. Thunderstorms in area at time of crash. Pilot was enroute from California to new jersey, had been flying 4 hours, 18 minutes. Awake at least 7 hours. Transited 1 time zone. No record of weather briefing or flight plan filed. Pilot…Oct 12, 1984 · N8868R · Destroyed NTSB SEA83LA209Accident · 2 fatalLimited investigationFinal reportBellanca 14-19-3 · Goldendale, WAThe pilot's inadequate preflight and in-flight planning, which resulted in flight into adverse weather conditions and clearance from trees not maintained. Factors contributing to the accident included the clouds, low ceilings, and turbulence.Jan 8, 1983 · N8807R · Destroyed NTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…Feb 22, 1982 · N8869R · Destroyed NTSB LAX81FA050Accident · 2 fatalClosedBellanca 14-19 · Parker, AZFeb 22, 1981 · N8503R · Destroyed NTSB MIA79FA099Accident · 1 fatalClosedBellanca 14-193 · Ozark, ALJul 4, 1979 · N7644E · Destroyed NTSB MIA75AM017Accident · 1 fatalClosedBellanca 14-193 · Jeffersonville, GASep 3, 1974 · N8840R · Destroyed NTSB CHI75AC025Accident · 3 fatalClosedBellanca 14-19 · Blue Ash, OHSep 3, 1974 · N8862R · Destroyed NTSB FTW67A0087Accident · 1 fatalClosedBellanca 14-19 · Mt.Pleasant, TXMar 3, 1967 · N7626E · Destroyed NTSB NYC66A0151Accident · 2 fatalClosedDowner 14-19 · Hartford, NYJun 14, 1966 · N8802R · Destroyed NTSB MIA65A0061Accident · 1 fatalClosedBellanca 14-19 · Bronson, FLDec 5, 1964 · N8820R · Destroyed NTSB UNK64X3831Accident · 2 fatalClosedBellanca 14-193 · Atkinson, NESep 6, 1964 · N8816R · Destroyed