NTSB investigations: NONE
2,123 cases on aircraft whose registry engine model is NONE. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, newest first
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 FTW98LA284Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Taos, NMThe pilot's improper flare. Contributing to the accident was the sudden wind shift which rendered the aircraft uncontrollable when the aircraft was on final approach to land.NTSB FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.NTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.NTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.NTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.NTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.NTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.NTSB FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.NTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.NTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.NTSB NYC98LA085Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Elk Garden, VAthe pilot's improper weather evaluation. The gusty wind condition was a related factor.NTSB LAX98LA092Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Williams, CAThe pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.NTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.NTSB LAX98LA084Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Prescott Valley, AZThe failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.NTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB NYC98LA011Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26A · Fairfield, PAThe improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.NTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.NTSB LAX98LA005Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Rancho Bernardo, CAThe pilot's intentional flight in high wind conditions and his improper in-flight planning.NTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.NTSB FTW98LA010Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMThe passenger failing to follow the pilot's instructions as to the proper brace position to assume for landing.NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW98LA008Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Albuquerque, NMthe passenger's failure to follow procedures/directives for the landing.NTSB FTW98LA014Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Caddo Mills, TXthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the gusty wind condition.NTSB ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…NTSB MIA97LA244Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Louisville, MSThe failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.NTSB IAD97LA118Accident · Serious injuriesLimited investigationFinal reportReynolds MARSKE-MONARCH 1997 · Sutton, WVThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A related factors was the pilot lack of familiarity with the airplane.NTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.NTSB SEA97LA194Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hamilton, MTThe pilot's excessive speed taxispeed and failure to maintain wing clearance from a taxiway sign.NTSB SEA97LA190Accident · Minor injuriesLimited investigationFinal reportLaister LP-49 · North Plains, ORThe pilot's selection of an inadequate landing site, and his failure to adequately plan his return glide back to his home gliderport. A factor contributing to the accident was rough terrain.NTSB CHI97LA305Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Columbia, MOthe pilot's improper planning/decision. The unfavorable wind was a related factor.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.NTSB FTW97LA288Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Briggs, TXThe pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.NTSB LAX97LA258Accident · Serious injuriesLimited investigationFinal reportCentrair ASW20F · Minden, NVthe pilot's improper planning/decision and subsequent encounter with gusty winds and strong downdrafts, which precluded reaching the airport and induced an unrecoverable high sink rate during an off-airport landing.NTSB CHI97LA216Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-8 · Menominee Falls, WIthe slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.NTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.NTSB MIA97LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Eustis, FLan in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.NTSB NYC97LA137Accident · Serious injuriesLimited investigationFinal reportAerostar-Raven S-60-A · Clyde, OHAn abrupt touchdown to avoid power lines which resulted in a hard landing. Contributing to the accident was the pilot's failure to properly brief the passengers for the landing.NTSB CHI97LA207Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Columbia, MOthe pilot's failure to properly judge the landing approach. The proximity of transmission wires was a related factor.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.