NTSB investigations: Raven S55A, 1984
5 cases on aircraft the registry lists as Raven S55A. 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 7 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2013 | 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 year(c.\"eventDate\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7480402'))
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 year(c."eventDate") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7480402'))
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 MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB NYC84FFJ03Accident · Serious injuriesFinal reportRaven S55A · Lakeville, NYWitnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious…NTSB ANC84LA104Accident · No injuriesLimited investigationFinal reportRaven S-55A · Anchorage, AKWhile apchg to land on a school ground, the balloon plt lowered a drop line for the ground crew, then looked forward & saw a power line. He told the ground crew not to touch the drop line. The drop line contacted & pulled one power line into another, causing…NTSB LAX84LA257Accident · Serious injuriesLimited investigationFinal reportRaven S-55A-707 · Glendale, AZDuring a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry…