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 LAX92LA192Accident · No injuriesLimited investigationFinal reportLaister Nugget · Bishop, CAThe pilot-in-command's improperly planned no-flap landing approach; failure to follow the checklist; and inadvertent gear retraction. Factors contributing to the accident were the buckling of the wing skin, cracking of the fuselage and the inoperative flaps.NTSB BFO92LA039Accident · No injuriesLimited investigationFinal reportLet L-13 · Lock Haven, PAA tow rope that broke at low altitude.NTSB FTW92LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Boerne, TXThe pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.NTSB SEA92LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Hood River, ORPoor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.NTSB ANC92LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Nome, AKThe pilot inadvertently stalled the airplane. Contributing to the accident was inadequate altitude.NTSB DEN92LA021Accident · Minor injuriesLimited investigationFinal reportCameron V-77 · Littleton, COThe pilot's improper landing procedure, including wrong compensation for wind conditions and improper use of the envelope dump control. A factor was: high wind.NTSB CHI92DEV01Accident · Serious injuriesFinal reportQuickie Quickie 1 · Carmi, ILAn engine bearing seizure and a premature forced landing flare.NTSB MIA92LA028Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Groveland, FLPoor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.NTSB BFO92LA003Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Waynesboro, VAImproper in-flight planning/decision by the instructor (CFI). Contributing to the accident was the instructor's failure to properly monitor the student's performance.NTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.NTSB LAX92LA021Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Fremont, CAThe pilot's inadequate altitude on final approach.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB NYC92LA013Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov Lark I-28-B2 · Blairstown, NJAn improperly planned approach which resulted in an inadvertent stall with insufficient altitude for recovery. A factor related to the accident was improper use of the flight controls by the pilot.NTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.NTSB MIA91LA223Accident · No injuriesLimited investigationFinal reportCentrair 101A · Groveland, FLThe pilot in command's poor in flight decision planning, and inadvertent stall mush while on approach to land. Contributing to the accident was his lack of total experience.NTSB DEN91LA137Accident · No injuriesLimited investigationFinal reportRaven Ralley RX7 · Englewood, COA hard landing and inadvertent deployment of the balloon heater. A factor was: inadvertent entanglement of a load cable with the heater activation device.NTSB FTW91LA161Accident · Serious injuriesLimited investigationFinal reportBarnes AX 7 · Baytown, TXThe crewmembers improper posture during landing which led to a serious injury.NTSB CHI91LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly X-7 · Altoona, IAWeather evaluation misjudged and overconfidence in personal ability. A factor related to the accident was high winds.NTSB LAX91LA378Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Mojave, CAThe glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…NTSB DEN91LA118Accident · No injuriesLimited investigationFinal reportLet L-13 · Aspen, COThe pilot turning off the runway with excessive speed.NTSB NYC91LA209Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · New Middletown, OHThe unfavorable wind (shift) encountered by the balloon during the initial takeoff climb.NTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.NTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.NTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.NTSB CHI91LA231Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIA collision with wires after the glider overshot the landing area due to inadvertent lowering of the flaps and no use of spoilers.NTSB CHI91LA219Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Plainfield, ILPilot's failure to attain proper alignment with the runway. A factor related to the accident was the high vegetation/crop in which the landing was made.NTSB CHI91FA212Accident · Serious injuriesField investigationFinal reportCentrair Pegasus 101B · Hinckley, ILThe failure of both pilots to maintain adequate visual lookout and ensure adequate separation during traffic pattern operations. A related factor is the non-standard uncontrolled airport procedures used by N126CC.NTSB CHI91FA212Accident · Serious injuriesField investigationFinal reportSlingsby Kestrel 19 · Hinckley, ILThe failure of both pilots to maintain adequate visual lookout and ensure adequate separation during traffic pattern operations. A related factor is the non-standard uncontrolled airport procedures used by N126CC.NTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB FTW91LA119Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Boerne, TXThe pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.NTSB DEN91FA083Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus C · Durango, COThe absence of thermal lift, the pilot's apprehension, and his lack of familiarity with the geographic area.NTSB CHI91LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Highland, ILThe pilot misjudged his touchdown point.NTSB CHI91LA183Accident · 1 fatalLimited investigationFinal reportBalloon Works FIREFLY-7B · Greenwood, MOThe inadequate briefing to the ground crew by the pilot, because the ground crewman did not understand the intent and objectives of the maneuver.NTSB ATL91LA106Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-200 · Marshallville, GAThe pilot's failure to maintain airspeed and the inadvertent stall/spin. A factor was the loss of thermal lifting action.NTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.NTSB LAX91LA211Accident · 1 fatalLimited investigationFinal reportGlasflugel Mosquito · Pearblossom, CAThe failure of the pilot to maintain adequate airspeed to avoid stalling the aircraft.NTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.NTSB LAX91LA163Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Lake Cobb, CAThat the pilot's visual lookout was improper. Contributing to this accident was the unmarked transmission wire.NTSB LAX91LA155Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26-D · Warner Springs, CAThat the pilot used poor planning/decision and failed to maintain flying speed. Contributing to his accident was the loss of thermal lift and lack of experience in this type of aircraft.NTSB BFO91LA034Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Buchanan, VAThe pilot's decision to attempt the takeoff with unfavorable winds.NTSB DEN91LA040Accident · No injuriesLimited investigationFinal reportAerostar RX7 · Durango, COThe pilot's failure to maintain obstacle clearance. Factors were: the unfavorable winds and the high obstructions in the flight path.NTSB NYC91LA066Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Williamstown, MAThe failure of the pilot to retract the speed brakes during the preflight, which resulted in the tow airplane being unable to attain sufficient altitude prior to releasing the glider, and the subsequent landing of the glider on unsuitable terrain.NTSB CHI91LA045Accident · No injuriesLimited investigationFinal reportLaister LP-49 · Warrensburg, MOFailure to maintain directional control by the pilot. Factors related to the accident are lack of total experience in type aircraft, and type of operation.NTSB CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB LAX90FA310Accident · 1 fatalField investigationFinal reportSchempp-Hirth NIMBUS-2C · California City, CAThe pilot's improper decision to execute the rapid climbing turn maneuver at an insufficient airspeed. Contributing to this accident was the premature dumping of the glider's water ballast.NTSB LAX90DVG18Accident · No injuriesFinal reportGlaser-Dirks D6-100G · Vacaville, CAThe unauthorized entry onto the runway by a vehicle operator.NTSB CHI90LA225Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Mottville, MIThe pilot's failure to maintain a proper decent rate during landing and his decision to initiate the flight in high winds conditions.NTSB LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.NTSB NYC90LA193Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Erwinna, PAInadvertent release of the tow line at low altitude. A contributing factor was the landing in unsuitable terrain.
Back to NONE