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 FTW97LA256Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Pagosa Springs, COThe pilot's improper inflight planning in that he allowed the glider to descend to too low an altitude and stray too far from the airport, exceeding the aircraft's glide capabilities. A factor was his failure to utilize maximum braking action.NTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.NTSB FTW97LA201Accident · No injuriesLimited investigationFinal reportCentrair 101C · Santa Fe, NMthe pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.NTSB ANC97TA074Accident · No injuriesFinal reportSchweizer SGS 1-26E · Fort Wainwright, AKthe pilot's inadequate preflight and improper planning/decision. Factors relating to the accident were: an unlatched canopy, and unsuitable terrain for landing.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.NTSB LAX97LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · San Diego, CAThe pilot's decision to increase sink rate to avoid flying into an obstacle with insufficient altitude remaining to reduce the sink rate prior to impact with the ground.NTSB LAX97LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Llano, CAthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper altitude and clearance from the boundry fence, during an approach to land on the runway. Factors relating to the accident were: the crosswind, and…NTSB MIA97LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Benton, TNThe failure of the pilot to maintain altitude and clearance from the trees on a ridge line.NTSB ANC97FA024Accident · 1 fatalField investigationFinal reportde Havilland DHC-4A · Sparrevohn, AKloss of the right engine propeller control oil, which led to an overspeed of the right engine and propeller, and necessitated a shut-down of the right engine; and failure of the pilot to maintain adequate altitude/distance from terrain during visual approach…NTSB MIA97LA074Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Clermont, FLthe pilot's improper planning/decision by electing to be towed aloft with a cold front nearby, which resulted in an in-flight encounter with wind gusts from the nearby cold front and subsequent in-flight collision with trees.NTSB MIA97LA046Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mulberry, FLThe pilot's failure to check that the spoiler handle was locked in the retracted position prior to takeoff.NTSB FTW97LA068Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Rio Rancho, NMThe passenger's failure to follow recommended procedures to properly brace for a high wind landing. A factor was the windshear.NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportCessna 182R · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.NTSB FTW97LA054Accident · No injuriesLimited investigationFinal reportLet L23 · Bryan, TXthe pilot misjudged his distance and altitude during the landing approach. Factors relating to the accident were: the high obstructions (power lines), and subsequent tailwind during the forced landing.NTSB CHI97LA022Accident · Serious injuriesLimited investigationFinal reportGalaxy AX8 · Columbia, MOthe pilot's selection of unsuitable terrain for landing. Factors relating to the accident were: the ditch, which was encountered during the landing; and high vegetation, which covered the ditch making it not visible to the pilot.NTSB LAX97LA028Accident · Serious injuriesLimited investigationFinal reportLeibert BD-5B · Phoenix, AZloss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.NTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.NTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.NTSB FTW97LA023Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMA sudden increase in wind velocity.NTSB IAD97LA004Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Krosno KR-03A · Kutztown, PAthe glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…NTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.NTSB FTW97LA004Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-59 · Sterling, COLoss of control when the pilot exceeded the velocity of stall while in a turn.NTSB LAX96FA344Accident · Serious injuriesField investigationFinal reportThunder and Colt Colt 240A · Phoenix, AZThe pilot's impairment of judgment and performance due to drugs which led to his misjudgment of his descent rate during landing. Contributing factors were: his failure to activate the deflation device (rip line) and turn off the pilot lights, improper use of…NTSB NYC97LA084Accident · No injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-S · Wadsworth, OHThe pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…NTSB CHI96LA349Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Stilwell, KSthe pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).NTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportBurkhart Grob 102 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.NTSB LAX96LA330Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Warner Springs, CAimproper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…NTSB IAD96LA142Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYthe pilot's failure to maintain adequate altitude and airspeed during the landing approach, resulting in a stall/spin and subsequent encounter with an embankment.NTSB NYC96LA172Accident · Minor injuriesLimited investigationFinal reportPzl-Bielsko SZD-59 · Franconia, NHThe pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.NTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.NTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.NTSB FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.NTSB ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.NTSB SEA96LA147Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19 · Salem, UTThe pilot's failure to attain a proper touchdown point during an off-airport landing. Factors relating to the accident were: loss of thermal lift, high obstructions (transmission wires) near the edge of the field that the pilot chose to land, and a bale of…NTSB NYC96LA140Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26E · Marston Mills, MAfailure of the pilot to maintain control of the glider while being towed during takeoff, which resulted in a pitch oscillation, failure of the tow cable, loss of airspeed, an inadvertent stall/spin, and an uncontrolled collision with the ground.NTSB FTW96LA303Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Gunnison, COthe pilot's inadequate weather evaluation. A factor was the high wind.NTSB FTW96LA292Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Gunnison, COThe pilot's improper planning/decision. The weather condition (sudden high wind) was a related factor.NTSB FTW96FA279Accident · 2 fatalField investigationFinal reportBurkhart Grob G103C Twin III Acro · Boulder, COPoor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…NTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.NTSB FTW96LA242Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · San Angelo, TXfailure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.NTSB ATL96LA089Accident · No injuriesLimited investigationFinal reportSchweizer SGS233A · Franklinton, NCthe failure of the instructor pilot to maintain control of the aircraft.NTSB LAX96LA218Accident · No injuriesLimited investigationFinal reportSchweizer 1-24 · Tehachapi, CAthe glider pilot's decision to land on the grass covered infield instead of the alternate runway, and the pilot's failure to maintain directional control. Contributing to the accident was the pilot's improper use of the spoilers and brakes.NTSB NYC96LA111Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Bloomingburg, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall spin and collision with trees.NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.NTSB FTW96LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Ft. Lupton, COthe pasenger's failure to follow the instructions given by the pilot during a briefing.NTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.NTSB FTW96LA201Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-233A · Odessa, TXthe pilot's failure to obtain the required airspeed resulting in a hard landing. A factor was the lack of thermal lift.NTSB ANC96LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKfuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…NTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.
Back to NONE