NTSB investigations: NONE

57 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with terrain/water”. 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
  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.

NTSB ATL83LA223Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Ashburn, GAThe plt was participating in a soaring contest & was on a round robin course from cordele, GA to perry, dawson, sylvester & back to cordele. On the return leg, there was insufficient lift to complete the trip, so an alternate landing site (wheat field) was…Jun 8, 1983 · N60LS · Substantial damageNTSB CHI83LA226Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Lansing, MIThe plt was participating in the national 15 meter championship meet. During a triangular course, he ran out of thermal activity & selected a field for a landing. From the air, he thought he had selected an alfalfa field with a 5 to 6 inch growth. However, he…May 24, 1983 · N20ZZ · Substantial damageNTSB MIA82DA186Accident · No injuriesFinal reportSchweizer SGS 1-26B · High Springs, FLThe pilot was on a round robin cross-country flight. On the last leg of the flight, he was unable to locate sufficient lift to reach the destination. A large, unobstructed field was selected for a landing. However, the field contained a stand of waist High…Sep 4, 1982 · N2460W · Substantial damageNTSB 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.…Jun 18, 1982 · N99954 · Substantial damageNTSB 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…Jun 16, 1982 · N7746S · Substantial damageNTSB 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…May 22, 1982 · N612BG · DestroyedNTSB 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…Mar 8, 1982 · N37978 · Substantial damage