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 LAX08LA254Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Jean, NVThe failure of both pilots to see and avoid the other aircraft while maneuvering over the airport.NTSB LAX08LA242Accident · No injuriesLimited investigationFinal reportGlaser-Dirks Flugzeugbau DG-100G · Truckee, CAA malfunction of the tow release mechanism.NTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.NTSB SEA08CA163Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Arlington, WAThe pilot's failure to maintain clearance from a tree while making an off-field landing in a glider. Contributing to the accident was the pilot's inadequate compensation for the gusting winds.NTSB MIA08CA146Accident · Serious injuriesData collectionFinal reportFirefly 7-15 · Jamestown, RIThe pilot's excessive descent maneuver.NTSB MIA08CA136Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Elmira, NYThe glider pilot's misjudged distance/altitude while soaring.NTSB CHI08CA202Accident · No injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Beloit, WIThe inadequate visual lookout by the driver of the golf cart and the air/ground communications not available to the golf cart driver during movement onto an active runway while the glider was landing.NTSB LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB NYC08CA236Accident · Minor injuriesData collectionFinal reportGlasflugel Standard Libelle · Front Royal, VAAircraft control was not maintained during cruise flight. Contributing to the accident was turbulence and inadvertent flight into adverse weather.NTSB LAX08CA136Accident · Minor injuriesData collectionFinal reportA. Schleicher ASW 27-18 · Peoria, AZThe pilot's misjudged distance and altitude while on final approach to land. A factor contributing to the accident was a downdraft.NTSB SEA08CA129Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Tehachapi, CAThe pilot's inadequate preflight procedures and failure to check the spoiler control position, which resulted in the inadvertent deployment of the spoilers during takeoff. A contributing factor was the pilot's misinterpretation of the tow pilot's instructions.NTSB SEA08LA119Accident · Serious injuriesLimited investigationFinal reportCameron Balloons C-100 · Phoenix, AZThe pilot's inadequate weather evaluation during the landing approach. Contributing to the accident were windshear and rocky terrain.NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.NTSB NYC08LA168Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Dansville, NYThe pilot's failure to attain the proper glide path and the flight instructor's delayed remedial action. Contributing to the accident was the encountered headwind.NTSB LAX08CA112Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Buckeye, AZThe passenger's failure to hear and follow the pilot's instructions to get down in the bottom of the balloon basket before the high wind landing. A contributing factor was the high wind condition.NTSB DEN08CA056Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Alamogordo, NMThe unsuitable terrain for landing. Contributing to the accident were the pilot's encounter with turbulence and the loss of visual contact with the tow plane.NTSB SEA08LA067Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Hollister, CAThe dual student's failure to maintain aircraft control while taxiing from the active runway and the delayed remedial action by the flight instructor. A contributing factor was the unfavorable high wind condition.NTSB NYC08CA031Accident · No injuriesData collectionFinal reportLet L-33 Solo · Louisburg, NCThe flight's encounter with an area of no thermal lift. Contributing factors to the accident were the pilot's inadvertent selection of unsuitable terrain with a hidden obstruction.NTSB SEA08CA011Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Tehachapi, CAThe pilot's misjudged distance/altitude that led to an undershoot, and his failure to attain the proper touchdown point.NTSB DEN08LA007Accident · No injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's inability to maintain aircraft control due to high winds, resulting in the aircraft coming in contact with an arroyo and a wall in a residential area.NTSB DEN08LA006Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-105 · Rio Rancho, NMthe pilot's inability to maintain aircraft control due to high winds resulting in the aircraft coming in contact with two houses.NTSB DEN08LA005Accident · Serious injuriesLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's inadequate inflight planning/judgment, and his selection of unsuitable terrain on which to make a landing. Contributing factors in this accident were the unfavorable wind, and the pilot misjudging his airspeed.NTSB DEN08LA004Accident · 1 fatalLimited investigationFinal reportAerostar S-66A · Albuquerque, NMThe pilot's failure to maintain adequate visual lookout and clearance resulting in an in-flight collision with power lines, and the ground crew's improper assistance. Contributing to this accident were the high wind, the pilot's diverted attention, low…NTSB DEN07CA163Accident · Serious injuriesData collectionFinal reportAerostar S81A · Hartsel, COthe pilot's inability to maintain the proper descent rate. A factor contributing to the accident was the unfavorable wind conditions.NTSB CHI07CA300Accident · Serious injuriesData collectionFinal reportCameron Balloons O-77 · Creston, IAThe pilot's inadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. Contributing to the accident was the high wind encountered during the balloon flight and the barbed-wire fence.NTSB DEN07LA152Accident · Serious injuriesLimited investigationFinal reportSlingsby Swallow Type T.45 · Hutchinson, KSThe pilot's failure to maintain aircraft control during a low altitude release resulting in an inadvertent stall/spin. Contributing factors were the pilot's decision to turn back to the airport at low altitude and the wind gust.NTSB CHI07CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Alliance, OHThe pilot's inattentiveness during the aircraft preflight and his failure to maintain clearance above the trees.NTSB SEA07LA250Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Morgan, UTThe pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.NTSB CHI07CA232Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Warrensburg, MOThe flight instructor's failure to maintain adequate airspeed and aircraft control, which resulted in a stall while on final approach. A factor in the accident were the two fences.NTSB NYC07CA172Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-26C · Windsor, VAThe pilot's failure to properly plan the approach to the airport, which resulted in an in-flight collision with a tree. A factor was the gusty wind conditions.NTSB MIA07CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26E · Big Flats, NYThe pilot's misjudged distance/altitude during approach resulting in collision with trees and the ground.NTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.NTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.NTSB MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.NTSB LAX07CA223Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Truckee, CAThe pilot's inadequate compensation for a wind gust during landing flare, which resulted in a hard landing.NTSB CHI07CA189Accident · Minor injuriesData collectionFinal reportCameron Balloons Z-77 · Battle Creek, MIThe whisper burner's fuel valve opening for undetermined reasons, which resulted in a fire after landing. A factor in the accident was the balloon envelope's parachute top not reseating.NTSB NYC07LA155Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau Speed Astir II · Centre Hall, PAThe pilot's inability to maintain control of the glider for undetermined reasons.NTSB ATL07CA101Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus-CS · Freehold, NYThe pilot's inadvertent activation of the tow release handle at a low altitude following an encounter with turbulence.NTSB NYC07CA151Accident · No injuriesData collectionFinal reportLet Super Blanik L-23 · Warren, VTThe glider's inadvertent encounter with windshear. A factor was the outflow from a nearby thunderstorm.NTSB SEA07CA175Accident · No injuriesData collectionFinal reportBurkhart Grob G102 Std Astir III · Wickenburg, AZThe pilot's inadequate compensation for wind conditions which resulted in an inflight collision with a cactus tree while landing. The loss of thermal lift, tailwind, gusts, and tree were contributing factors to the accident.NTSB ANC07LA046Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Clear, AKThe dual student's misjudged distance/altitude during the final approach to land, and the flight instructor's inadequate supervision of the student, which resulted in an undershoot, and substantial damage.NTSB LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.NTSB DFW07LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Castroville, TXThe flight instructor's inability to maintain directional control due to the drag created by the tall grass adjacent to the runway. A contributing factor was the tall grass.NTSB LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.NTSB SEA07LA132Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Lake Elsinore, CAThe glider's encounter with a downdraft while in the traffic pattern, resulting in insufficient altitude to reach the airport. A contributing factor was the pilot's selection of an unsuitable off-airport landing area, which led to an on-ground collision with…NTSB NYC07CA118Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 · Franconia, NHThe pilot's failure to obtain the proper touchdown point. A factor in the accident was an encounter with an updraft while on approach.NTSB DEN07CA092Accident · No injuriesData collectionFinal reportCentrair 101C · Alamogordo, NMThe pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.NTSB NYC07LA114Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · New Holland, PAUnfavorable winds and terrain during a precautionary landing.NTSB LAX07CA149Accident · Minor injuriesData collectionFinal reportBurkhart Grob G102 Club Astir Iiib · Minden, NVthe pilot's misjudgment of distance and altitude that resulted in an undershoot of the runway.NTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.
Back to NONE