Skip to content

Bellanca 14-13-3

NTSB investigations · 17

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.aircraft_model_code IN ('1201006') 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.aircraft_model_code IN ('1201006')
  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.aircraft_model_code IN ('1201006')
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 LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…May 20, 2005 · N6511N · Destroyed NTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.Jun 25, 2001 · N29C · Substantial damage NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.May 16, 2001 · N6522N · Destroyed NTSB LAX99LA210Accident · No injuriesLimited investigationFinal reportBellanca BL-14-13 · Taft, CAThe pilot's inability to maintain control of the aircraft due to the aileron control cables being crossed and reversed. The pilot's lack of a thorough pre-flight inspection and the pilot not referencing a manual during the repairs on the aircraft is also…Jun 7, 1999 · N74476 · Destroyed NTSB MIA77AA054Accident · 4 fatalClosedBellanca 14-13 · Thomaston, GAApr 16, 1977 · N74483 · Destroyed NTSB MIA72FLA41Accident · No injuriesClosedBellanca 1413-3 · Starke, FLMay 7, 1972 · N69L · Substantial damage NTSB LAX71AL025Accident · 1 fatalClosedBellanca 14-133 · San Fernando, CANov 7, 1970 · N6513N · Destroyed NTSB FTW71FPM09Accident · Serious injuriesClosedBellanca 14-133 · Tulsa, OKOct 3, 1970 · N6505N · Substantial damage NTSB MIA71DKW01Accident · No injuriesClosedBellanca 14-13 · Lawrenceburg, TNJul 18, 1970 · N74480 · Substantial damage NTSB FTW69F0494Accident · No injuriesClosedBellanca 14-13 · Mountain Home, ARApr 20, 1969 · N6502N · Substantial damage NTSB NYC68F0196Accident · Serious injuriesClosedBellanca 14-13 · So.Plainfield, NJSep 22, 1967 · N6503N · Substantial damage NTSB SEA68F0026Accident · 2 fatalClosedBellanca 14-13 · Everett, WAFeb 4, 1967 · N6524N · Destroyed NTSB DEN67D0161Accident · No injuriesClosedBellanca 14-133 · Portales, NMNov 3, 1966 · N6502N · Substantial damage NTSB MIA66D0430Accident · No injuriesClosedBellanca 14-13 · Palatka, FLJul 25, 1965 · N74485 · Substantial damage NTSB DEN65A0079Accident · 3 fatalClosedBellanca 14-133 · Panguitch, UTJun 13, 1965 · N6525N · Destroyed NTSB UNK64X3980Accident · No injuriesClosedBellanca 1413W · Uvalde, TXSep 14, 1964 · N74480 · Substantial damage NTSB UNK64X1718Accident · No injuriesClosedBellanca 14133 · Costa Mesa, CAMay 11, 1964 · N74476 · Substantial damage

Back to Bellanca 14-13-3