NTSB investigations: Cameron Balloons Z-90
7 cases on aircraft the registry lists as Cameron Balloons Z-90. 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
| 2001 | 1 |
|---|---|
| 2004 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 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 ('1880300'))
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 ('1880300'))
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 CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.NTSB CEN21LA164Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons Z-90 · Celina, TXThe malfunction of the balloon’s envelope venting system during landing in high wind, which resulted in the balloon being dragged along the ground, substantially damaging the envelope.NTSB CEN16LA352Accident · No injuriesLimited investigationFinal reportCameron Z90 · Morrill, NEThe pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB CEN12CA347Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Sellersburg, INThe balloon pilot’s failure to maintain clearance from power lines.NTSB IAD04CA045Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Dover, PAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing. A factor was the relatively high winds (for balloon flight.)NTSB FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.