NTSB investigations: Downer BELLANCA 14-19-3
12 cases on aircraft the registry lists as Downer 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 2008 | 1 |
Where
Open the mapLatest cases
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_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 ('3080116'))
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 ('3080116'))
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 DEN08LA095Accident · No injuriesLimited investigationFinal reportDowner Bellanca 14-19-3 · N. Little Rock, ARThe loss of engine power due to the incorrect and improper installation of throttle and mixture cables by unknown maintenance personnel.NTSB NYC73FHM11Accident · No injuriesClosedBellanca 260 · Sea Bright, NJNTSB FTW71FPA33Accident · No injuriesClosedBellanca 14-19 · Addison, TXNTSB IAD71AI038Accident · 1 fatalClosedBellanca 14-193 · Jamesville, VANTSB LAX70AL050Accident · 1 fatalClosedBellanca 14-19 · Show Low, AZNTSB MIA70F0289Accident · No injuriesClosedBellanca 14-193 · Jacksonville, FLNTSB DEN67F0213Accident · No injuriesClosedBellanca 14-19 · Albuquerque, NMNTSB FTW67D0403Accident · Minor injuriesClosedBellanca 14-19 · Plainview, TXNTSB NYC67F0283Accident · No injuriesClosedDowner 14-19 · Painted Post, NYNTSB MIA66D0203Accident · No injuriesClosedBellanca 14-13 · Dawson, GANTSB UNK64X0716Accident · No injuriesClosedBellanca 14193A · S Plainfield, NJNTSB MIA65D0030Accident · No injuriesClosedBellanca 260 · Destin, FL