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 CHI98LA253Accident · Serious injuriesLimited investigationFinal reportCameron A105 · Howell, MIThe pilot's failure to visually recognize hazards associated with meteorological phenomenon. A contributing factor was the weather condtion.NTSB CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.NTSB IAD98LA114Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hammonton, NJImproper maintenance, which resulted in an over-pressurized landing gear.NTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.NTSB SEA98LA155Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Douglas, WAThe pilot's failure to maintain clearance from objects on the ground. Factors include misjudgment of weather conditions (unfavorable winds).NTSB ATL98LA090Accident · Minor injuriesLimited investigationFinal reportMbb Phoebus C · Perry, SCThe pilot's loss of control during takeoff, leading to an in-flight collision with the ground. A factor was the pilot's lack of recent experience in a high performance glider.NTSB FTW98LA284Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Taos, NMThe pilot's improper flare. Contributing to the accident was the sudden wind shift which rendered the aircraft uncontrollable when the aircraft was on final approach to land.NTSB FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.NTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.NTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.NTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.NTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.NTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.NTSB FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.NTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.NTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.NTSB NYC98LA085Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Elk Garden, VAthe pilot's improper weather evaluation. The gusty wind condition was a related factor.NTSB LAX98LA092Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Williams, CAThe pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.NTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.NTSB LAX98LA084Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Prescott Valley, AZThe failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.NTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB NYC98LA011Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26A · Fairfield, PAThe improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.NTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.NTSB LAX98LA005Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Rancho Bernardo, CAThe pilot's intentional flight in high wind conditions and his improper in-flight planning.NTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.NTSB FTW98LA010Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMThe passenger failing to follow the pilot's instructions as to the proper brace position to assume for landing.NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW98LA008Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Albuquerque, NMthe passenger's failure to follow procedures/directives for the landing.NTSB FTW98LA014Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Caddo Mills, TXthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the gusty wind condition.NTSB ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…NTSB MIA97LA244Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Louisville, MSThe failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.NTSB IAD97LA118Accident · Serious injuriesLimited investigationFinal reportReynolds MARSKE-MONARCH 1997 · Sutton, WVThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A related factors was the pilot lack of familiarity with the airplane.NTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.NTSB SEA97LA194Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hamilton, MTThe pilot's excessive speed taxispeed and failure to maintain wing clearance from a taxiway sign.NTSB SEA97LA190Accident · Minor injuriesLimited investigationFinal reportLaister LP-49 · North Plains, ORThe pilot's selection of an inadequate landing site, and his failure to adequately plan his return glide back to his home gliderport. A factor contributing to the accident was rough terrain.NTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB FTW97LA288Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Briggs, TXThe pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.NTSB LAX97LA258Accident · Serious injuriesLimited investigationFinal reportCentrair ASW20F · Minden, NVthe pilot's improper planning/decision and subsequent encounter with gusty winds and strong downdrafts, which precluded reaching the airport and induced an unrecoverable high sink rate during an off-airport landing.NTSB CHI97LA216Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-8 · Menominee Falls, WIthe slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.NTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.NTSB MIA97LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Eustis, FLan in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.NTSB NYC97LA137Accident · Serious injuriesLimited investigationFinal reportAerostar-Raven S-60-A · Clyde, OHAn abrupt touchdown to avoid power lines which resulted in a hard landing. Contributing to the accident was the pilot's failure to properly brief the passengers for the landing.NTSB CHI97LA207Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Columbia, MOthe pilot's failure to properly judge the landing approach. The proximity of transmission wires was a related factor.
Back to NONE