NTSB investigations: Raven S55A, 1983
3 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\") = 1983
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") = 1983
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 FTW83LA440Accident · No injuriesLimited investigationFinal reportRaven S-55A · Santa Fe, NMThe plt elected to land the balloon between 2 power lines. During the landing, the balloon impacted another power line that was installed across the main lines. Electrical arcing occurring occurred. The balloon attachment cables, skirt & gondola were scorched…NTSB CHI83LA235Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Rockford, ILThe pilot was alone in the basket and was practicing a steep approach to land. The pilot said the reason for his injuries was not the hard landing but lack of preparation for it.NTSB ANC83LA049Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Anchorage, AKThe two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the…