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 LAX90LA282Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Liano, CAThe pilot's inflight decision was improper. Contributing to this accident was the pilot's self-induced pressure.NTSB LAX90LA278Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA277Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 SLI · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA264Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Sparks, NVThe inability of the pilot to maintain control of the glider as a result of injuries sustained during an inflight encounter with turbulence. Contributing to the accident was turbulent weather condition encountered.NTSB LAX90DXQ02Accident · Minor injuriesFinal reportLeffler/Mcfarlane LM-1 · Sierraville, CAPilot's failure to see and avoid a tree during his landing approach.NTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.NTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.NTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.NTSB LAX90LA220Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Davis, CAThe failure of the pilot to properly manage the fuel valves to provide adequate fuel pressure to the burner.NTSB LAX90LA212Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-3A · Vacaville, CAThe pilot's inflight loss of control for undetermined reasons.NTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.NTSB ATL90LA125Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Montevallo, ALThe inattentiveness of the glider pilot to the aborted takeoff of the tow plane, which resulted in his delayed action in attempting to execute a forced landing. These actions resulted in an inadvertent stall and the aircraft collided with the terrain.NTSB NYC90LA115Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Wallkill, NYThe pilot's failue to maintain flying speed which resulted in a stall. A factor was the pilot's diversion of attention.NTSB NYC90LA114Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider Lsif Sailplane · Mayville, NYJammed flight controls in flight due to a bent aileron push-rod.NTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.NTSB CHI90LA140Accident · No injuriesLimited investigationFinal reportLet L-13 · Oxford, MIThe glider pilot's failure to maintain adequate aircraft control during the touchdown and landing roll. The poorly executed approach to landing, and rough/uneven terrain were contributing factors in this accident.NTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.NTSB LAX90LA206Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Napa, CAThe pilot's improper flare technique which resulted in a hard landing. A factor in the accident was the sudden appearance of a high wind condition.NTSB NYC90LA092Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Unionville, PAThe loss of thermal lift which necessitated a forced landing on unsuitable terrain covered by trees and high obstructions.NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.NTSB DEN90LA086Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morgan, UTSeparation of the tow rope and the pilot's failure to establish an appropriate descent rate as he returned to land. Contributing to the accident were the tailwind and the unsuitable terrain for landing beyond the runway end.NTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.NTSB NYC90LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer S2-33A · Brookhaven, NYCause of the accident was a hard landing after the pilot stalled the glider while turning onto final approach.NTSB LAX90LA103Accident · No injuriesLimited investigationFinal reportPitts S1T · Ramona, CAThe pilots loss of directional control during landing.NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…NTSB CHI90LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe dual student did not maintain proper glidepath and his misjudgment for compensation for wind conditions resulted in a collision with utility wires. The cfi's inadequate supervision during the duel flight operation contributed to the accident.NTSB LAX90LA041Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Sun City, AZInadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.NTSB SEA90LA032Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Las Vegas, NVThe pilot of the raven RX7, N5710Y, failed to maintain adequate control to avoid a collision with the firefly 7, N4070W, and both pilots did not maintain adequate clearance from each other during the practice maneuver.NTSB SEA90LA032Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Las Vegas, NVThe pilot of the Raven RX7, N5710Y, failed to maintain adequate control to avoid a collision with the firefly 7, N4070W, and both pilots did not maintain adequate clearance from each other during the practice maneuver.NTSB BFO90LA021Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Paint Bank, VAThe pilot's improper inflight planning which led to an off-airport landing after encountering deteriorating lift conditions. Contributing factors were the mountainous terrain and lack of a suitable landing area.NTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.NTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.NTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.NTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).NTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.NTSB NYC89LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-32 · Plymouth, CTImproper compensation for wind conditions by the pilot. A factor related to the accidetn was: the downdraft.NTSB DEN89LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Louisville, COThe pilot's failure to adequately evaluate the weather prior to takeoff. High winds developed during the Balloon flight which resulted in a rough landing.NTSB MIA89LA206Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Ms State Univ, MSImproper in-flight planning/decison by the pilot. Contributing factors were: failure of the tow vehicle driver to use/maintain the proper speed, the pilot's lack of total flying experience, and high vegetation (uncut hay).NTSB ATL89LA184Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Alabaster, ALThe glider pilot's poor evaluation of area weather conditions during the flight, which necessitated an off-airport precautionary landing and led to a collision with rough terrain during the landing rollout. Factors contributing to the accident were the…NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.NTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.NTSB NYC89LA152Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26 · Elmira, NYAn inadvertent encounter with a downdraft.NTSB LAX89DVG08Accident · No injuriesFinal reportHomebuilt BG 12 B-D · Montague, CAPilot misjudged the airplane's altitude and failed to extend the spoilers.NTSB DEN89LA145Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Rio Rancho, NMA hard landing due to the pilots failure to accurately evaluate the weather conditions along with a delay in making a precautionary landing. Factors contributing to the accident were high winds and wind shear along with rough/uneven terrain.NTSB ATL89FA158Accident · 3 fatalField investigationFinal reportBalloon Works Firefly 8B · Garner, NCImproper planning/decision by the pilot, and his delay in initiating a climb as the Balloon converged on the tv tower.NTSB NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.NTSB LAX89LA167Accident · Serious injuriesLimited investigationFinal reportSchweizer T-26E · Fremont, CAThe pilot's failure to maintain sufficient airspeed in an effort to avoid obstacles during an inadequately planned approach.NTSB FTW89FA081Accident · Serious injuriesField investigationFinal reportHead Balloons AX8-88 · Troy, TXImproper planning/decision by the pilot, and inadequate supervision by the check pilot, which resulted in their failure to maintain clearance from the tree during the landing. Factors related to the accident were: the high wind & tree(s).
Back to NONE