NTSB investigations: Cameron Balloons US A-105
5 cases on aircraft the registry lists as Cameron Balloons US A-105. 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
| 1990 | 1 |
|---|---|
| 1998 | 1 |
| 2001 | 1 |
| 2008 | 1 |
| 2023 | 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 ('1880211'))
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 ('1880211'))
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 WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.NTSB NYC02LA015Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-105 · Morgantown, WVThe passengers failure to remain in the balloon basket after landing which resulted in the inadvertent lift-off of the balloon and subsequent injury to the pilot. A factor related to the accident was the pilot's failure to perform a passenger briefing prior…NTSB CHI98LA253Accident · Serious injuriesLimited investigationFinal reportCameron A105 · Howell, MIThe pilot's failure to visually recognize hazards associated with meteorological phenomenon. A contributing factor was the weather condtion.NTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.