NTSB investigations: NONE, PA

9 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Loss of control - in flight”. 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 per year

19942026
NTSB investigations: NONE, PA per year, 1994–2026: 9 cases
19941
19972
19991
20001
20041
20061
20072

Latest cases

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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
    AND 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\" = 250))
  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 MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.Jul 14, 2007 · N775SS · Substantial damageNTSB NYC07LA155Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau Speed Astir II · Centre Hall, PAThe pilot's inability to maintain control of the glider for undetermined reasons.Jul 1, 2007 · N176SS · Substantial damageNTSB NYC06LA127Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-35 · Eighty Four, PAThe pilot's incapacitation, which resulted in a loss of aircraft control during approach, and subsequent collision with trees.May 28, 2006 · N91MC · Substantial damageNTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.May 22, 2004 · N12PX · DestroyedNTSB 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.May 7, 2000 · N67TT · DestroyedNTSB NYC99LA170Accident · No injuriesLimited investigationFinal reportPilatus B-4 · Erwinna, PAThe pilot-in-command's failure to maintain aircraft control.Jul 8, 1999 · N20RK · Substantial damageNTSB 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.Oct 13, 1997 · N1154N · Minor damageNTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.Aug 28, 1997 · N19LK · Substantial damageNTSB BFO94LA083Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-C · Fairfield, PAThe pilot-in-command's failure to maintain control of the airplane during the maneuver.Jun 1, 1994 · N166W · Substantial damage