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 FTW82DA264Accident · No injuriesFinal reportGlassflugel 604 · Refugio, TXThe pilot accidently released the tow line at about 50 feet AGL when his parachute caught on the tow release handle. In attempting to turn to the runway, he dragged a wing. The glider fuselage broke aft of the cockpit.NTSB NYC82DA153Accident · No injuriesFinal reportSchweizer SGS-1-36 · New London, NHWhile being towed during takeoff, the weak link on the tow rope failed when the glider was about 125 ft AGL. The pilot started to land on a golf course ahead, but spotted golfers in his intended landing area. The glider stalled while he was in a steep turn.…NTSB NYC82DHD14Accident · Serious injuriesFinal reportRaven S-66A · Washington Town, NJThe pilot reported that moments after initial ground contact (during landing), a passenger reported that he thought his leg had fractured. The passenger reported that the fracture occurred after initial impact, when another passenger leaned or stepped on his…NTSB SEA82DA092Accident · No injuriesFinal reportBlanik L-13 · Driggs, IDThe pilot held a commercial, airline transport certificate, but had only a student glider certificate. During a towed takeoff, witnesses observed the spoilers extend after about 200 ft of ground roll. The tow pilot gave an arm signal to indicate a problem.…NTSB ATL82DA168Accident · Serious injuriesFinal reportSchweizer SGS-2-32-A · Williamson, GAOn downwind, the pilot saw another glider on the runway. He maintained altitude until the glider cleared the runway. When clear the pilot started his descent extending the spoilers fully. The pilot stated that when he reached his desired altitude and leveled…NTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…NTSB CHI82DA178Accident · No injuriesFinal reportBalloon Works FIREFLY-7 · Wyoming, MIThe pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.NTSB NYC82DHA09Accident · No injuriesFinal reportBryan HP-18 · Hazelton, PAThe pilot departed blairstown, PA on a round robin, triangular course to bethel and dallas, PA and return to blairstown. He stated that while he was proceeding from bethel to dallas he encountered heavy sinking conditions in addition to a head wind.…NTSB FTW82FQA18Accident · 1 fatalFinal reportBlanik L-13 · Los Lunas, NMDuring landing the left wing struck a bystander who wandered onto the edge of the asphalt overrun taking photographs of the landing. There is a caution sign posted on the north access road of the runway.NTSB DEN82DA064Accident · No injuriesFinal reportSchweizer SGS-2-33A · Colorado Spring, COThe student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft…NTSB LAX82FA136Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Tulare, CAThe glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane…NTSB FTW82DQG17Accident · Serious injuriesFinal reportBalloon Works 7-B · Masterson, TXAfter making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking…NTSB LAX82DA123Accident · Minor injuriesFinal reportBölkow Phoebus C · Livermore, CAWhile returning to the gliderport, the aircraft had insufficient altitude to glide to the runway. The pilot elected to land in a field about 1/2 mile from the gliderport. Just before touchdown, he diverted his attention from the landing and became concerned…NTSB FTW82DA099Accident · Minor injuriesFinal reportAirmate HP-10 · El Paso, TXOn the first flight since purchase of the aircraft, the pilot stated that he was released from the tow at 1700 ft AGL and climbed in a thermal to 2000 ft AGL where he allowed the aircraft to stall and spin. The pilot stated that he had difficulty in…NTSB FTW82DA086Accident · No injuriesFinal reportSchreder RS-15 · Hempstead, TXThe pilot reported that he lost directional control on his first flight in this high performance glider. He stated that the right wing began to drag when the runner released it early. He attempted to lift the wing with left aileron and rudder. The glider…NTSB LAX82DA090Accident · No injuriesFinal reportSchweizer SGS1-260 · Phoenix, AZDuring the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther.NTSB LAX82DA089Accident · Minor injuriesFinal reportBarnes Balloon AX7 · Napa, CAThe pilot attempted to land short of powerlines after aborting an ascent to safely clear them because of what he reported as unstable air. The gondola bounced and slid into the wires. The pilot stated that electric current passed through the load lines and a…NTSB LAX82FUJ28Accident · No injuriesFinal reportBalloon Works Firefly · Phoenix, AZThe pilot was landing in a vacant lot when the light and variable wind shifted and started blowing the Balloon toward powerlines. Just prior to the wind shift, the Balloon was descending rapidly. Rather than make a hard landing, the pilot tried to "burn" his…NTSB LAX82DA098Accident · No injuriesFinal reportRaven S-55A · Glendale, AZThe balloon made a hard landing on rocky desert terrain and the occupants were thrown out. The balloon became airborne while unoccupied and the envelope collided with power lines. The wind was reported to be blowing at 5 to 8 KTS.NTSB NYC82FNA05Accident · Serious injuriesClosedRaven S-55A · Shirley, MANTSB LAX82FUJ07Accident · No injuriesClosedRaven AX-7 · Phoenix, AZNTSB NYC82DFJ04Accident · No injuriesClosedSchweizer 1-26 · Lockport, NYNTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PANTSB CHI82FA005Accident · 1 fatalClosedBLN Works FF-7 · Delaware, OHNTSB FTW82FQA04Accident · Serious injuriesClosedRaven RX-6 · Albuquerque, NMNTSB CHI81FEK31Accident · No injuriesClosedBLN Works FF-7B · Johnstown, OHNTSB LAX81DUK09Accident · No injuriesClosedSchweizer 1-26 · Sun City, AZNTSB CHI81FA100Accident · 1 fatalClosedSchweizer SGS232 · Waynesville, OHNTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJNTSB NYC81FNA25Accident · Serious injuriesClosedSchweizer 2-32 · Plymouth, MANTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WINTSB LAX81DUJ99Accident · Serious injuriesClosedGlasflugel H301B · Maricopa, AZNTSB NYC81FNE27Accident · No injuriesClosedSchweizer 1-23H · Plymouth, CTNTSB CHI81FA090Accident · Serious injuriesClosedRaven RX-7 · Barrington Hls, ILNTSB NYC81FFJ21Accident · Minor injuriesClosedNeukom S3 · Horseheads, NYNTSB FTW81DPA20Accident · No injuriesClosedSchleicher ASW-19 · Floyd, TXNTSB FTW81DPA19Accident · No injuriesClosedGlasflugel H-201B · Campbell, TXNTSB FTW81FQA41Accident · No injuriesClosedSchweizer 1-26 · Moriarty, NMNTSB LAX81FUQ27Accident · 1 fatalClosedShhreder HP-11A · Pearlblossom, CANTSB CHI81DEC37Accident · No injuriesClosedVliegtuigbo SA-013 · Adrian, MINTSB FTW81FQG42Accident · Serious injuriesClosedSchneider LS-4 · Hobbs, NMNTSB LAX81FA104Accident · No injuriesClosedSchweizer 2-33A · Maricopa, AZNTSB LAX81DUG36Accident · Minor injuriesClosedPiccard AX-6 · Corona, CANTSB CHI81DEK20Accident · No injuriesClosedSchweizer 1-36 · Montpelier, OHNTSB NYC81DFJ16Accident · No injuriesClosedSchweizer 126E · Mayville, NYNTSB FTW81DQD27Accident · No injuriesClosedThunder BLN AX7-65 · Las Cruces, NMNTSB FTW81FQA32Accident · 1 fatalClosedSchleicher ASW-20 · Las Vegas, NMNTSB DEN81FTE40Accident · Minor injuriesClosedSchweizer 134 · Colorado Spgs, CONTSB CHI81DEK18Accident · No injuriesClosedSchleicher ASW15 · London, OHNTSB LAX81DXQ18Accident · No injuriesClosedEiriavion PIK-20 · Minden, NV