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.engine_model_code IN ('00000')
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.engine_model_code IN ('00000')
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 LAX89LA145Accident · No injuriesLimited investigationFinal reportLet L-13 · Hemet, CAInadequate crew coordination between the ground lineman and the blanik pilot, and failure of the blanik pilot to maintain clearance between his aircraft and the parked glider. A factor related to the accident was the proximity of the parked glider to the…NTSB MIA89LA102Accident · Serious injuriesLimited investigationFinal reportAdams AX-9 · Jacksonville, FLThe failure of a passenger to follow pre-briefed instructions during landing.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.NTSB LAX89LA038Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Vacaville, CADuring final approach, the glider collided with a fence. A witness stated that, 'the pilot simply let the glider get too low and too slow and hit a fence.' There were no mechanical problems reported prior to the accident. The pilot did not file an acdt report.NTSB DEN89DTE01Accident · 1 fatalFinal reportHicks/Mervin RH-3 · Erie, CONTSB DEN89LA013Accident · Minor injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe plt, with two pax aboard a hot air balloon, participated in the 1988 Albuquerque, NM international balloon fiesta. The plt said he received a wx briefing and then departed in VFR wx conditions. After aprx 45 min of flt, the plt said he encountered…NTSB DEN89LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally II · Rio Rancho, NMThe commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was…NTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…NTSB LAX88LA328Accident · No injuriesLimited investigationFinal reportCentrair 101 · Vacaville, CAThe pilot flew over a field at 700 ft. a.g.l. to see if it was safe for landing. He turned the glider to establish a downwind leg. He then turned to the base leg. While turning onto final approach at a low altitude, the glider pitched up and rolled to the…NTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.NTSB DEN88FA199Accident · 1 fatalField investigationFinal reportGlasflugel H-301 · Salida, COWitnesses said the acft was aprx 200 ft AGL on the downwind leg, but close in to the rwy as it returned to the arpt for landing. Acft entered a 60 deg right bank to base leg. Nose rose slightly and acft rolled inverted. Acft made one-half to three-quarters…NTSB CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…NTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…NTSB NYC88LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYThe plt reported to the local police that he was having trouble getting lift and was attempting an off airport landing when the acft stalled at low alt and crashed. The pilot did not file an accident report.NTSB SEA88FA131Accident · 1 fatalField investigationFinal reportApplebay Zuni 2 · Wellington, NVThe plt (with only 13 hrs flt time in the hi performance sailplane) took off at 1330 PDT. Psn rprts with her gnd crew were normal until 1630, then another plt offered to relay messages. After ctcg her gnd crew, the otr plt tried calling her back at aprx 1645,…NTSB LAX88LA255Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Pilot Hill, CADuring a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds…NTSB SEA88LA128Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Minden, NVAcft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…NTSB SEA88LA123Accident · Serious injuriesLimited investigationFinal reportKaman HH43 · Joseph, ORThe pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.NTSB DEN88LA152Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Fort Collins, COThis Balloon flt was part of a rally. The flt departed from a stadium, climbed to 500' and then made a controlled descent and landing. After the next takeoff and climb to about 125' when the burner was turned off the plt noticed that fuel was not flowing to…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 ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…NTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.NTSB DEN88LA132Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Moriarty, NMThe pvt glider plt was completing a five hr endurance flight. During the turn from base to final, the glider encountered a 15 kt xwind and overshot the turn. The plt attempted to 'buttonhook' back toward the intended touchdown point. Witnesses stated that…NTSB DEN88LA165Accident · No injuriesLimited investigationFinal reportHall HP-18 · Westcliffe, COThe plt said his glider was being towed for takeoff from a dry, dusty, grass strip. He said the tow plane blew up the dust and he was unable to see to maintain alignment with the 75 ft wide strip. There was a drop off on the lt side of the strip and tall…NTSB LAX88LA221Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Fremont, CADuring a local flt, the glider encountered a windshear and lost altitude. The pilot was unable to regain the lost altitude and a forced landing was made where during the landing roll the glider collided with rough terrain.NTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…NTSB LAX88LA182Accident · No injuriesLimited investigationFinal reportSlingsby T59D Kestrel 19 · Middletown, CANTSB NYC88LA142Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Red Creek, NYWhile the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about…NTSB MKC88LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55 · Burlington, IAWhile attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along…NTSB ATL88LA149Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Chester, SCWhile thermaling during the sailplane competition, N45BD was slightly higher and to the left of N295SZ. N45BD made a right turn and struck the right inboard wing section of N294SZ with the outboard wing tip of N45BD. The outboard wing tip of N45BD separated…NTSB LAX88LA156Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20D · Saint Helena, CAThe flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…NTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.NTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CANTSB LAX88LA137Accident · Minor injuriesLimited investigationFinal reportAvian Magnum IX · Phoenix, AZDuring a local flight in a hot air balloon, while descending, the deflation line malfunctioned. It was found that the release pulley had no roller and the rope was knotted and jammed in the pulley. The vent could not be activated in this condition.NTSB ATL88LA120Accident · Serious injuriesLimited investigationFinal reportSlingsby Dart T-51 · Whitwell, TNThe glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull…NTSB LAX88LA131Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Phelan, CANTSB MIA88LA121Accident · No injuriesLimited investigationFinal reportSchleicher K-8B · Miami, FLThe plt stated that he had placed the glider into a mild dive & was indicating 90 to 95 mph, well below redline speed when the whole section of the trailing edge of the wing from the aft spar & wing root out to a dist of about 6 ft, separated from the acft.…NTSB NYC88LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Newport, VTDuring landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over.NTSB DEN88LA081Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Los Lunas, NMNTSB ATL88MA089Accident · 3 fatalMajor investigationFinal reportBritish Aerospace 3101 · Springfield, OHA company designated instr and two f/o trainees were conducting a FAR 135 trng flt. The third apch was terminated with ago-around initiated over the rwy threshold at about 50 ft. after climbing to about 150 ft, the acft was observed to oscillate in yaw,…NTSB FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.NTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZNTSB DEN88LA045Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Dona Ana, NMThe commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically…NTSB MIA88LA036Accident · No injuriesLimited investigationFinal reportRaven S-66A · Naples, FLAfter liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then…NTSB CHI88LA016Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Union, ILThe glider was approaching to land when, according to the pilot, he noticed the aircraft was descending 'too fast' and his airspeed was 'too slow'. The pilot then realized he wasn't going to make the runway and decided to land the glider in a nearby field.…NTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…NTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…NTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…NTSB DEN87LA232Accident · No injuriesLimited investigationFinal reportNational Balloon 858 · Colorado Spring, COThe commercial balloon plt was competing in a balloon race. While landing, with the basket on the ground, the balloon drifted into power lines. A large hole was burned in the envelope, and the basket was damaged. The plt and two passengers jumped from the…
Back to NONE