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 DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.NTSB SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.NTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.NTSB SEA01LA150Accident · Minor injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Wenatchee, WAFailure to maintain clearance from terrain during a low altitude turn. The second pilot overshooting the runway was a contributing factor to the accident.NTSB SEA01LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Quincy, WAThe failure of the impeller assembly as a consequence of impeller rub and binding within the impeller collector case for undetermined reasons.NTSB DEN01LA143Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Morgan, UTthe pilot's inadvertent lowering of the flaps and her failure to extend the spoilers.NTSB SEA01LA147Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Rock Island, WAThe student pilot's improper inflight planning and decision (delay in establishing an approach to a suitable landing area) and his subsequent failure to attain the proper glidepath for the selected landing area, resulting in an overshoot of the selected…NTSB CHI01LA277Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Marlette, MIGround crew personnel improperly connected the tow winch cable prior to takeoff which resulted in one side of the winch cable coming disconnected. Factors associated with the accident were the ditch and the tree branch which the airplane contacted.NTSB CHI01LA250Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 STD Astir III · Faribault, MNThe pilot's failure to maintain adequate airspeed during the landing which resulted in a stall.NTSB LAX01LA249Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Minden, NVThe student pilot's early deployment of full spoilers, resulting in an excessive sink rate and subsequent hard landing. A factor was the instructor's lack of time to take remedial action.NTSB IAD01LA080Accident · Serious injuriesLimited investigationFinal reportAerostar International RXS-8 · Flemington, NJpilot's continued flight into known adverse weather conditions, which resulted in a hard landing. A factor was the downdrafts.NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.NTSB IAD01LA076Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Front Royal, VAthe pilot's inadequate altitude/clearance from a tree along his final approach path.NTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…NTSB DEN01LA116Accident · Serious injuriesLimited investigationFinal reportCameron Balloons N-210 · Rio Rancho, NMthe pilot's inadvertent weather encounter with wind shear, and the resulting inability to maintain the proper landing descent rate, which resulted in a hard landing. A factor was the high wind weather condition.NTSB NYC01LA150Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Mumford, NYThe ground handler's failure to follow instructions to release her line during the balloon's unintended ascent, due to panic.NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportSchleicher Ka-6E · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.NTSB NYC01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26E · New Milford, CTthe student pilot's improper decision to fly northeast of the airport with winds from the southwest, and his subsequent diverted attention to the glider's proximity to the airport while he searched for thermals, which resulted in an off airport landing.NTSB NYC01LA114Accident · No injuriesLimited investigationFinal reportSchweitzer 136 · Tinicum Twnshp., PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.NTSB DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.NTSB LAX01LA142Accident · Minor injuriesLimited investigationFinal reportSchweizer 2-33A · Peoria, AZThe glider's encounter with a dust devil during takeoff that resulted in a loss of control.NTSB SEA01LA058Accident · Serious injuriesLimited investigationFinal reportAvia Stroitel AC-5m · Bozeman, MTthe pilot's improper remedial action upon experiencing the unexpected opening of the aircraft's canopy during the initial part of the takeoff climb. Factors include his attention being diverted to the open canopy, his failure to use a checklist to ensure he…NTSB MIA01LA038Accident · No injuriesLimited investigationFinal reportGrob G102 · Clermont, FLThe pilot's premature extension of the speed brakes on landing resulting in the glider colliding with trees short of the runway.NTSB LAX01LA038Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Lake Elsinore, CAThe pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.NTSB NYC01LA020Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Shirley, NYThe pilot's improper in-flight decision to abort the glide toward the airport. A factor was the pilot's failure to comply with the published best glide speed.NTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.NTSB CHI00LA295Accident · Serious injuriesLimited investigationFinal reportAerostar S-81A · Custer, SDThe ground crew's failure to maintain control of the balloon until all passengers were disembarked. A factor related to the accident was the gust of wind.NTSB NYC00LA251Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Wurtsboro, NYThe pilot's improper weather evaluation and decision to initiate a flight with an approaching rain shower. A factor in this accident was heavy rain, which reduced visibility.NTSB MIA00LA239Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Zephyrhills, FLThe student pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB DEN00LA150Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Edwards, COLack of crew coordination when the ground crew failed to hold the balloon in position following landing as the pilot expected them to do. A factor was power lines.NTSB LAX00LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly II · Phoenix, AZThe pilot's failure to use pibals or other on site wind determination devices, and his subsequent failure to detect adverse wind conditions prior to launch of the balloon.NTSB FTW00LA224Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Tulsa, OKThe passenger's failure to comply with the briefing administered by the pilot. Factors were the passenger's physical impairment due to an injury sustained during the initial ground impact and the high wind condition.NTSB DEN00LA146Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Steamboat Spgs, COThe pilot's failure to maintain clearance from a bush during the balloon landing.NTSB NYC00LA208Accident · No injuriesLimited investigationFinal reportSchreder HP-11-A · Dansville, NYThe pilot's improper in-flight decision to continue the flight with an unfavorable wind. A factor related to the accident was the loss of thermal lift.NTSB CHI00LA196Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · River Falls, WIthe unfavorable wind condition for landing and control of the balloon during landing not possible by the pilot.NTSB CHI00LA193Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Manchester, MIthe downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.NTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.NTSB MIA00TA189Accident · Serious injuriesFinal reportBell OH-58 · Rome, GAThe pilots failure to ensure the helicopter was on level terrain after landing. The left skid came off the ground after the passenger exited the helicopter, the slope capability was exceeded, the helicopter encountered dynamic rollover, and rolled over on its…NTSB LAX00LA217Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26 · Prescott, AZDiminished control during the landing phase of operation due to a partial blockage of the elevator controls by a microphone that became lodged in the control stick well.NTSB IAD00LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe pilot's failure to attain a proper touchdown point.NTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.NTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.NTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.NTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.NTSB ATL00LA054Accident · No injuriesLimited investigationFinal reportSchweizer SGU2-22E · Farmington, NCThe pilot's misjudgment of traffic pattern altitude that resulted in an off-field landing and the subsequent collision with the ground. A factor was rough terrain.NTSB SEA00LA085Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Seaside, ORThe pilot's improper decision to continue to a point where he could not be assured of reaching a safe landing-out site if he encountered an area of significant sink after departing his planned route of flight. Factors include downdrafts, terrain that…NTSB MIA00LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Jacksonville, FLthe student pilot's misjudgment of the aircraft's altitude and subsequent maneuver to avoid an obstacle, that resulted in a loss of airspeed, an inadvertent stall, and an inflight loss of control, which resulted in damage to the aircraft during landing.
Back to NONE