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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…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 CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.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 FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S55A · 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 DEN88LA201Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Fort Morgan, COThe plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he…NTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.NTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMNTSB CHI87LA167Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Springfield, MITwo hot air balloons were involved in a midair collision during a sanctioned balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…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 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…NTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…NTSB DEN84LA273Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Littleton, COPlt stated that the entire flt was uneventful. The female passenger had her knees bent in preparation for landing but her body was twisted in a direction that was opposite to her feet when the balloon made ground contact.NTSB NYC84FFJ03Accident · Serious injuriesFinal reportRaven S55A · Lakeville, NYWitnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious…NTSB ANC84LA104Accident · No injuriesLimited investigationFinal reportRaven S-55A · Anchorage, AKWhile apchg to land on a school ground, the balloon plt lowered a drop line for the ground crew, then looked forward & saw a power line. He told the ground crew not to touch the drop line. The drop line contacted & pulled one power line into another, causing…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…NTSB 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 CHI83LA235Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Rockford, ILThe pilot was alone in the basket and was practicing a steep approach to land. The pilot said the reason for his injuries was not the hard landing but lack of preparation for it.NTSB ANC83LA049Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Anchorage, AKThe two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the…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 CHI82DA345Accident · Serious injuriesFinal reportRaven S55 · Mattawan, MIDuring a landing in an open field the balloon collided with wires and started to burn. The pilot stated that her attention was temporarily distracted as the balloon approached a corral with horses and she was adjusting the maneuvering valve for landing. The…NTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.NTSB NYC82FNA05Accident · Serious injuriesClosedRaven S-55A · Shirley, MANTSB LAX82FUJ07Accident · No injuriesClosedRaven AX-7 · Phoenix, AZNTSB FTW82FQA05Accident · No injuriesClosedRaven S-55A · Corrales, NMNTSB FTW82FQA02Accident · Minor injuriesClosedRaven S-55A · Albuquerque, NMNTSB ANC81DAG36Accident · Serious injuriesClosedRaven S-55A · Anchorage, AKNTSB MIA81FLD33Accident · Serious injuriesClosedRaven S55A · Englewood, FLNTSB FTW81DQA21Accident · Serious injuriesClosedRaven AX-7 · Rio Rancho, NMNTSB LAX81DUJ18Accident · No injuriesClosedRaven S-55A · Sun City West, AZNTSB LAX81DUJ19Accident · Serious injuriesClosedRaven S-55A · Sedona, AZNTSB NYC80FHA16Accident · Serious injuriesClosedRaven S55 · Upr Mkfld Twp, PANTSB MKC80DA033Accident · Serious injuriesClosedRaven S55A · Council Bluffs, IANTSB IAD80FKW04Accident · Serious injuriesClosedRaven S55A · Knoxville, TNNTSB MIA80FA018Accident · 4 fatalClosedRaven S-55A · Davie, FLNTSB DEN80FA002Accident · 2 fatalClosedRaven S55AX7 · Albuquerque, NMNTSB OAK78DVD43Accident · Serious injuriesClosedRaven S-55A · Tracy, CANTSB DEN76DQA44Accident · No injuriesClosedRaven S-55A · Albuquerque, NMNTSB NYC76AN031Accident · No injuriesClosedRaven S55A · Greenwich, CT
Back to Raven S55A