NTSB investigations: Adams Balloon A55

6 cases on aircraft the registry lists as Adams Balloon A55. 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

19792026

NTSB investigations: Adams Balloon A55 per year, 1979–2026: 6 cases
1979	1
1980	1
1986	1
1989	1
1990	1
2003	1

Where

Open the map

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 ('0050103')) 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 ('0050103'))
  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 ('0050103'))
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 DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.Jun 15, 2003 · N4031Z · Destroyed NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.Jan 21, 1990 · N4021L · No damage NTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.Oct 8, 1989 · N1059S · Substantial damage NTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.Apr 20, 1986 · N10600 · No damage NTSB MIA80DLA27Accident · Minor injuriesClosedAdams A55S · Gainesville, FLJun 7, 1980 · N9073A · Destroyed NTSB MKC80DCA04Accident · Serious injuriesClosedAdams,Md A55 · Ballwin, MODec 9, 1979 · N1060N · Minor damage