NTSB investigations: Raven S55A, 1985
2 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\") = 1985
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") = 1985
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 SEA85LA089Accident · Serious injuriesLimited investigationFinal reportRaven R-7 · Mt. Vernon, WAThe plt discovered after a hard landing that his leg was broken. This was the students second solo in hot air balloons.NTSB DEN85LA078Accident · No injuriesLimited investigationFinal reportRaven S55A · Littleton, COThe balloon envelope collided with power lines after dragging the basket & occupants aprx 200 yards along an open fld and through a fence which damaged the basket containing the occupants. The balloon plt said that the wind was only 5 KTS at takeoff but after…