NTSB investigations: Raven S55A
4 cases on aircraft the registry lists as Raven S55A, where the first occurrence was “In flight encounter with weather”. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1996 | 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 ('7480402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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 ('7480402')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 FTW96LA292Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Gunnison, COThe pilot's improper planning/decision. The weather condition (sudden high wind) was a related factor.NTSB LAX87LA120Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Tucson, AZDuring a pleasure flight, the pilot reported that upon take-off, the wind was calm. While in-flight the wind increased and the pilot prepared for a high wind landing. The balloon touched-down hard and hit a bush. The pilot and one passenger were ejected from…NTSB LAX87LA070Accident · Serious injuriesLimited investigationFinal reportRaven S55A/AX7 · Peoria, AZPrior to lift-off the pilot noted that the wind conditions were calm. During the flight, the surface winds began to increase. The pilot prepared his passengers for a high wind landing and began to lightly vent off hot air. The balloon began descending at…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…