NTSB investigations: Raven S55A, NM
11 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
| 1976 | 1 |
|---|---|
| 1979 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2001 | 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.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA'
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 DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMNTSB 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 FTW83LA011Accident · Serious injuriesLimited investigationFinal reportRaven AX-7 · Albuquerque, NMThe balloonist attempted to abort a landing due to wind conditions and believes he encountered a downdraft. The balloon descended and landed on a fence and became airborne again. The wind had picked up to about 15 or 20 knots so the balloonwas traveling…NTSB FTW82FQA05Accident · No injuriesClosedRaven S-55A · Corrales, NMNTSB FTW82FQA02Accident · Minor injuriesClosedBarnes AX-7 · Albuquerque, NMNTSB FTW81DQA21Accident · Serious injuriesClosedRaven AX-7 · Rio Rancho, NMNTSB DEN80FA002Accident · 2 fatalClosedRaven S55AX7 · Albuquerque, NMNTSB DEN76DQA44Accident · No injuriesClosedRaven S-55A · Albuquerque, NM