Skip to content

NTSB investigations: Bellanca 14-19

28 cases on aircraft the registry lists as Bellanca 14-19. 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.aircraft_model_code IN ('3080102', '1250010')) 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.aircraft_model_code IN ('3080102', '1250010'))
  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.aircraft_model_code IN ('3080102', '1250010'))
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 WPR09LA290Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Columbia, CAThe failure of the left main landing gear drag link as a result of overstress fracture. Contributing to the accident was maintenance personnel's failure to detect a small crack in the left main landing gear drag link during the most recent annual inspection.Jun 11, 2009 · N6561N · Substantial damage NTSB LAX06FA233Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Arcata, CAThe pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…Jul 17, 2006 · N522A · Destroyed NTSB CHI05CA043Accident · No injuriesData collectionFinal reportBellanca 14-19 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A contributing factorwas the approach light.Dec 10, 2004 · N6563N · Substantial damage NTSB LAX03LA032Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Napa, CAthe pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.Nov 16, 2002 · N501A · Substantial damage NTSB LAX01FA160Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Casa Grande, AZA fuel leak on the cabin and engine sides of the firewall with a probable origin at the firewall pass-through fitting for the fuel pressure gage line. The fire likely began on the engine side of the firewall near the bottom with the explosive ignition of the…May 1, 2001 · N521A · Destroyed NTSB LAX89LA269Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Chandler, AZAn engine power loss for undetermined reasons.Aug 8, 1989 · N514A · Substantial damage NTSB MKC82DA076Accident · Minor injuriesFinal reportBellanca 14-19 · Hays, KSThe pilot had purchased the aircraft in Iowa and had obtained a ferry permit to fly it to his home in California. In the vicinity of Hays, Kansas, the fuel tank he was using ran dry. He switched to another tank, turned on the electric boost pump and tried to…May 9, 1982 · N501A · Substantial damage NTSB DEN81FTK15Accident · Minor injuriesClosedBellanca 14-19 · Arlington, SDJul 24, 1981 · N529A · Destroyed NTSB CHI77FEX53Accident · No injuriesClosedBellanca 14-19 · Mccordsville, INSep 27, 1977 · N6555N · Substantial damage NTSB NYC77FGM02Accident · Serious injuriesClosedBellanca 14-19 · Fort Littleton, PAOct 15, 1976 · N526A · Substantial damage NTSB CHI76FEK20Accident · No injuriesClosedBellanca 14-19 · Cambridge, OHJul 2, 1976 · N6560N · Substantial damage NTSB LAX73AL062Accident · 3 fatalClosedBellanca 14-19 · Parker, AZJun 7, 1973 · N6581N · Destroyed NTSB SEA72FYC46Accident · Serious injuriesClosedBellanca 1419-2 · Hermiston, ORJun 7, 1972 · N7698B · Destroyed NTSB LAX72FUQ87Accident · 1 fatalClosedBellanca 14-19 · Prt Hueneme, CAMay 7, 1972 · N527A · Destroyed NTSB NYC72FIA13Accident · No injuriesClosedBellanca 14-19 · Friendly, MDJan 1, 1972 · N522A · Substantial damage NTSB CHI72DEI26Accident · No injuriesClosedBellanca 14-193 · Painesville, OHDec 29, 1971 · N6553N · Substantial damage NTSB OAK68F0348Accident · No injuriesClosedBellanca 14-19 · Sacramento, CAApr 3, 1968 · N6585N · Substantial damage NTSB FTW68F0273Accident · No injuriesClosedBellanca 14-19 · Shreveport, LAOct 13, 1967 · N9835B · Substantial damage NTSB MKC68F0192Accident · Minor injuriesClosedBellanca 14-19 · Vichy, MOAug 16, 1967 · N526A · Destroyed NTSB OAK68D0150Accident · No injuriesClosedBellanca 14-19 · Ukiah, CAAug 9, 1967 · N6570N · Substantial damage NTSB DEN66D0057Accident · No injuriesClosedBellanca 14-19 · Ft Grant, AZJun 26, 1965 · N6575N · Substantial damage NTSB DEN65D0085Accident · No injuriesClosedBellanca 14-19 · Bowie, AZApr 17, 1965 · N6575N · Substantial damage NTSB UNK65X0921Accident · No injuriesClosedBellanca 14-19 · Kearney, NEDec 5, 1964 · N520A · Substantial damage NTSB UNK65X0475Accident · No injuriesClosedBellanca 1419 · Centerburg, OHOct 29, 1964 · N6556N · Substantial damage NTSB UNK64X4086Accident · No injuriesClosedBellanca 1419 · Madison, MSSep 21, 1964 · N132M · Substantial damage NTSB UNK64X3950Accident · Serious injuriesClosedBellanca 1419 · Willits, CASep 12, 1964 · N508A · Substantial damage NTSB UNK64X1866Accident · No injuriesClosedBellanca 1419 · Gardenville, PAMay 21, 1964 · N511A · Substantial damage NTSB UNK64X0115Accident · No injuriesClosedBellanca 1419 · Holly Spring, MSJan 2, 1964 · N6577N · Substantial damage