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 NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB ATL93LA138Accident · No injuriesLimited investigationFinal reportMolino PIK-20 · Jonesville, NCThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB DEN93LA085Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Durango, COThe failure of the tow plane pilot to warn the glider pilot that he was releasing the tow line. A factor was: an inadvertent stall by the pilot in command.NTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.NTSB DEN93LA080Accident · Minor injuriesLimited investigationFinal reportGlasflugel Standard Libell · Boulder, COImproper rigging of the spoiler system by maintenance personnel, which caused an uncommanded spoiler deployment and prevented spoiler retraction by the pilot. A factor was unsuitable terrain for a forced landingNTSB SEA93LA141Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe pilot's failure to attain the proper touchdown point. Factors to the accident were: lack of familiarity with geographic area and the grass.NTSB CHI93LA230Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Ionia, MIThe pilot in command's failure to maintain the proper glidepath.NTSB LAX93LA250Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Salida, CAthe pilot's failure to attain the proper touchdown point during the attempted landing. A factor in the accident was the unfavorable wind conditions for the balloon landing.NTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.NTSB ATL93LA097Accident · No injuriesLimited investigationFinal reportLet L-13 · Elberta, ALThe pilot's inadequate preflight planningNTSB SEA93LA119Accident · No injuriesLimited investigationFinal reportApplebay Zuni · Deer Park, WAImproperly planned approach by the PIC.NTSB DEN93LA062Accident · No injuriesLimited investigationFinal reportSchleicher ASH 25 E · Peyton, COThe encounter with a downdraft.NTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsNTSB NYC93LA084Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Buchanan, VAThe pilot's improper planning/decision, inadequate crew coordination, and failure to maintain directional control. The unfavorable wind and proximity of obstructions were related factors.NTSB LAX93LA283Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Phoenix, AZThe pilot's inadequate planned approach to the landing area.NTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.NTSB FTW93FA115Accident · Minor injuriesField investigationFinal reportChance Vought F4U-4 · Breckenridge, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landingNTSB LAX93LA296Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 160A · Chandler, AZThe pilot's failure to adequately evaluate the weather conditions and subsequent uncontrolled touchdown resulting in a hard landing. Gusty wind conditions were a factor in the accident.NTSB MIA93IA052Incident · Minor injuriesIncident investigationFinal reportBalloon Works Firefly 7-15 · Orlando, FLPoor in-flight planning/decision by the pilot, and excessive descent resulting in a hard landing.NTSB LAX93LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Peoria, AZThe balloon's encounter with a gusty wind shear condition during the final descent for landing at an altitude insufficient for the pilot to take corrective action to prevent a hard landing.NTSB LAX93LA048Accident · 1 fatalLimited investigationFinal reportRans S-10 Sakota · San Jose, CA1) The loss of engine power due to undetermined reason(s), and, 2) the pilot not maintaining airspeed above the power off stall speed while maneuvering to the runway resulting in an inadvertent stall/spin. A factor in this accident was the pilot not having…NTSB LAX93LA031Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIThe flight's encounter with unforecasted unfavorable winds (loss of thermal lift) and downdrafts while on final approach to the runway.NTSB SEA93LA017Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Green River, UTThe inadequate preflt planning/preparation by the pilot resulting in inflt encounter with weather and his failure to maintain proper rate of descent during an emergency forced landing. A factor relating to the accident was the turbulent weather conditions.NTSB NYC93LA032Accident · Minor injuriesLimited investigationFinal reportLet LF-13 · Readington, NJThe pilot's poorly planned approach for landing which resulted in an off airport landing in unsuitable terrain.NTSB LAX93LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe pilot's inadequate planned approach to the runway, and, his improper use of the flight controls which resulted in an inadvertent accelerated stall/spin.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.NTSB SEA93LA005Accident · No injuriesLimited investigationFinal reportSchweizer SSG 2-33A · Heber City, UTThe proper alignment was not maintained by the pilot. A factor relating to the accident was the sign located beside the runway.NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.NTSB BFO92LA130Accident · No injuriesLimited investigationFinal reportSchweizer 1-26D · Blairstown, NJThe pilot's failure to use spoilers which resulted in a landing overrun. Contributing was the pilot's lack of familiarity with the aircraft.NTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.NTSB LAX92LA352Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Flugzeugbau · Truckee, CAThe pilot's poorly planned approach. Lack of supervision in the type of aircraft was a factor.NTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.NTSB CHI92DET01Accident · Serious injuriesFinal reportFrost Briegleb/BG-12A · Lake Village, INInadvertent stall and spin with inadequate altitude for recovery.NTSB LAX92LA343Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103 · Truckee, CAThe inadequate aircraft maintenance and flight manuals and unavailable information pertaining to the inspection of the spoiler system. Contributing to this accident was the worn and jammed spoiler attachment limiting block.NTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.NTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.NTSB CHI92LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Manchester, MIThe pilot's improper inflight planning/decisions, failure to make a precautionary landing when he realized he was too low to reach the airport, and attempting to stretch his glidepath to reach the runway.NTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.NTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…NTSB NYC92LA126Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Waynesboro, VAThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall while on approach. Factors related to the accident were: the pilot's lack of experience, an improperly planned approach, and the gusty winds.NTSB FTW92LA167Accident · No injuriesLimited investigationFinal reportGlasflugel 201B · Briggs, TXThe inadvertent ground loop by the pilot. Factors were the downdraft and the rough/uneven terrain.NTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.NTSB SEA92LA118Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Deer Park, WAThe inadvertent activation of flight spoilers by the pilot and his failure to maintain airspeed, resulting in loss of control during takeoff. A factor relating to the accident was the presence of an irrigation sprinkler that was impacted by the aircraft…NTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.NTSB CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.NTSB LAX92LA207Accident · 1 fatalLimited investigationFinal reportLawrence H. Macey Quicksilver GT500 · Perris, CAThe pilot's failure to maintain control of his airplane for undetermined reasons.NTSB LAX92LA285Accident · No injuriesLimited investigationFinal reportSchweizer 1-36 · Hemet, CAThe pilot's inadvertent selection of unsuitable terrain for the precautionary landing. A factor in the accident was his failure to obtain a preflight weather briefing.NTSB SEA92LA089Accident · 1 fatalLimited investigationFinal reportPilatus B-4 PC 11A · Wenatchee, WAFailure by the pilot to maintain airspeed, resulting in aircraft stall.
Back to NONE