Final NTSB investigations: Raven Industries S77A
5 cases on aircraft the registry lists as Raven Industries S77A. 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
| 1985 | 1 |
|---|---|
| 1987 | 3 |
| 1989 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7480650'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7480650'))
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 DEN89LA145Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Rio Rancho, NMA hard landing due to the pilots failure to accurately evaluate the weather conditions along with a delay in making a precautionary landing. Factors contributing to the accident were high winds and wind shear along with rough/uneven terrain.NTSB LAX87LA284Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Tucson, AZDuring a local sightseeing balloon flight, the plt was making a landing at an open construction site. The gondola touched down then skipped three times and came to rest on the edge of a ledge aprx 10 ft in height. The balloon tipped over the edge and collided…NTSB DEN87LA174Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Silverthorne, COThe commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose…NTSB DEN87FA069Accident · 1 fatalField investigationFinal reportRaven S-77A · Park City, UTWhile on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted…NTSB DEN85LA127Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Fort Collins, COThe balloon basket containing 8 pass'g & 2 crewmembers brushed alongside a fence during lndg. One pass'g who had been jostled by the landing became a victim of 1ACERATIONS & a broken arm from contact with barbed wire fence. The plt stated that the wind was…