NTSB investigations: Raven Industries RX6
15 cases on aircraft the registry lists as Raven Industries RX6. 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 | 2 |
|---|---|
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1984 | 1 |
| 1988 | 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 ('7480502'))
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 ('7480502'))
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 LAX88LA276Accident · Serious injuriesLimited investigationFinal reportRaven RX-6 · Sun City, CAThe pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…NTSB NYC84FNC05Accident · Serious injuriesFinal reportRaven RX 6 · North Lebannon, MEStudent balloon pilot was on third supervised solo flt with his flt instructor acting as member of the chase crew. Plt was controlling descent with short bursts of propane burner. Ground contact was hard enough to cause the balloon skirt to continue downward…NTSB FTW82DQA23Accident · Serious injuriesFinal reportRaven RX-6 · Albuquerque, NMThe pilot reported that the balloon was inflated and launched at about 0700 MDT. Later, the wind velocity increased and a final landing was made at about 0930 MDT. During the landing, a ground crewmember's leg was broken when it was hit by the gondola.NTSB FTW82FQA04Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NMNTSB DEN81DTE65Accident · Serious injuriesClosedRaven RX-6 · Golden, CONTSB LAX81DUJ28Accident · No injuriesClosedRaven RX-6 · Peoria, AZNTSB DEN80FQA23Accident · No injuriesClosedRaven RX-6 · Albuquerque, NMNTSB CHI79DEX37Accident · No injuriesClosedRaven RX-7 · Shelbyville, INNTSB MKC79DTK18Accident · Serious injuriesClosedRaven RX-6 · Sioux Falls, SDNTSB MIA78DLD53Accident · No injuriesClosedRaven RX-6 · Tampa, FLNTSB IAD77DLT03Accident · No injuriesClosedRaven RX6 · Huntingdon, TNNTSB MKC76FCD41Accident · Minor injuriesClosedRaven RX-6 · Carlisle, IANTSB MIA76DKG56Accident · Serious injuriesClosedRaven RX-6 · Albany, GANTSB CHI76AC018Accident · Serious injuriesClosedRaven RX-6 · Island Lake, ILNTSB DEN75AD064Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NM