Skip to content

NTSB investigations: NONE, PA

104 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'))
  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."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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC83LA229Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G103 · Julian, PAThe student plt & instructor (CFI) were practicing pattern work & landings. During the 1st 3 patterns, the wind was calm, however, by the time they were on their 4th pattern, the wind increased & became gusty. While the student was flying the pattern, he…Aug 29, 1983 · N906BG · Substantial damage NTSB NYC83LA197Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Fairfield, PADuring the apch, the plt encountered unfavorable wind conditions & the glider touched down long. In order to avoid an embankment beyond the end of the strip, the plt turned toward a parallel rwy overrun area. Subsequently, the left wing hit two 55 gal drums…Jul 28, 1983 · N6BM · Substantial damage NTSB NYC83LA190Accident · No injuriesLimited investigationFinal reportLet L-13 · Fredericksburg, PAAfter lift-off from a tow takeoff, the towplane was unable to attain the normal tow airspeed of 65 to 75 mph & continuedat about 55 mph. The glider plt thought the towplane was having engine problems, & as the two acft circled the arpt, theglider plt released…Jul 24, 1983 · N32360 · Substantial damage NTSB NYC83LA154Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Freeport, PAThe glider collided with a fence during landing. The glider had experienced loss of lift shortly after a release from tow at 2500 ft AGL. Heavy sink and alt loss was encountered and continued. The pilot started a long straight in final approach to land but it…Jun 5, 1983 · N65859 · Substantial damage NTSB NYC83LA099Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Erwinna, PAThe glider was on a dual instructional flight for landing practice. On the final approach to landing the glider lost lift after experiencing excessive sink and clipped the tops of trees. The glider landed short of the intended area and the wings and nose of…Apr 17, 1983 · N2706H · Substantial damage NTSB NYC83LA076Accident · No injuriesLimited investigationFinal reportBurkhart Grob G10Z Astir CS · Buena Vista, PAThinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft…Mar 12, 1983 · N142SS · Substantial damage NTSB NYC83LA001Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26 · Kutztown, PAThe student pilot reported that while he was landing the glider, he overshot. Subsequently, the glider collided with a signboard and pole.Oct 3, 1982 · N2515H · Substantial damage NTSB NYC82DA183Accident · No injuriesFinal reportSchweizer SGS-2-33A · Eighty Four, PAThe tow line released at 40 feet AGL in a glider tow launch. The glider pilot tried to land on the runway but landed adjacent to it and collided with a tree which ground-looped the glider. The tow hitch mechanism was broken off at the tubing cluster & was…Jul 31, 1982 · N7774S · Substantial damage 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.…May 10, 1982 · N77BF · Substantial damage NTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PAOct 24, 1981 · N2979H · Substantial damage NTSB NYC80;GM29Accident · No injuriesClosedBLN Works FF-7 · Indiana, PAAug 31, 1980 · N2127H · Substantial damage NTSB NYC80FGT20Accident · Serious injuriesClosedSchreder HP-11A · Julian, PAAug 29, 1980 · N4742G · Substantial damage NTSB NYC80FGT10Accident · No injuriesClosedSchweizer SGS233 · Jersey Shore, PAApr 20, 1980 · N2440W · Substantial damage NTSB NYC80FGT01Accident · No injuriesClosedSchweizer SGS135 · Port Matilda, PAOct 14, 1979 · N34182 · Substantial damage NTSB NYC79DGT11Accident · No injuriesClosedPiccard AX6 · Huntsdale, PAMar 17, 1979 · N62US · Destroyed NTSB NYC79FHA06Accident · No injuriesClosedSchweizer 2-33A · Kutztown, PADec 23, 1978 · N2056T · Substantial damage NTSB NYC78DHA40Accident · No injuriesClosedSchweitzer 1-35C · Kutztown, PASep 30, 1978 · N2776H · Substantial damage NTSB NYC79FGM01Accident · Minor injuriesClosedDuster BU-18 · Eighty Four, PASep 23, 1978 · N12DQ · Substantial damage NTSB NYC78FGM49Accident · Serious injuriesClosedSchweizer 2-33 · Freeport, PASep 2, 1978 · N33941 · Substantial damage NTSB NYC78DHA31Accident · Minor injuriesClosedSchweizer 233 · Hilltown, PAJul 30, 1978 · N2467W · Substantial damage NTSB NYC78DGT04Accident · Serious injuriesClosedPickard AX-1 · New Holland, PAFeb 12, 1978 · N76JW · No damage NTSB NYC78FHA01Accident · No injuriesClosedSchweizer 2-33 · Beltzville, PAOct 15, 1977 · N1196S · Substantial damage NTSB NYC77FGM26Accident · Serious injuriesClosedSchweizer SGS126 · Brownsville, PAMay 22, 1977 · N17908 · Substantial damage NTSB NYC77FGT13Accident · No injuriesClosedSchweizer 2-33A · Philipsburg, PAMar 25, 1977 · N5758S · Minor damage NTSB NYC77FHA15Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAFeb 16, 1977 · N33993 · Substantial damage NTSB NYC76DHA49Accident · Minor injuriesClosedSchweizer SGS126 · Erwinna, PAAug 21, 1976 · N1102S · Substantial damage NTSB NYC76FGT26Accident · Minor injuriesClosedSchweizer SGS233 · Fredericksburg, PAAug 3, 1976 · N2440W · Substantial damage NTSB NYC76FHA44Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PAAug 1, 1976 · N33920 · Substantial damage NTSB NYC76FGM41Accident · No injuriesClosedSchleicher ASW-15 · Claysburg, PAAug 1, 1976 · N15DC · Substantial damage NTSB NYC76FGT23Accident · No injuriesClosedSchweizer SGS126 · Monterey, PAMay 8, 1976 · N8653R · Substantial damage NTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damage NTSB NYC76FGT13Accident · Serious injuriesClosedSchweizer 2-33 · Unionville, PADec 3, 1975 · N2400W · Destroyed NTSB NYC76FGT05Accident · No injuriesClosedSchemp Cirrus · Fairfield, PASep 13, 1975 · N6485 · Substantial damage NTSB NYC75DGM41Accident · No injuriesClosedScheibe 55 · Holidaysburg, PAJun 8, 1975 · N8364 · Substantial damage NTSB NYC75DHA41Accident · Serious injuriesClosedSchweizer 2-32 · Mount Pocono, PAMay 24, 1975 · N65973 · Substantial damage NTSB NYC75FGM36Accident · Serious injuriesClosedSchweizer SGU222 · Butler, PAMay 10, 1975 · N2749Z · Substantial damage NTSB NYC75DGT16Accident · No injuriesClosedSchleicher KA6 · Lemont, PAMar 15, 1975 · N1771R · Substantial damage NTSB IAD74FIA16Accident · No injuriesClosedFlug-Undfah DIA-18 · Latrobe, PAMay 13, 1974 · N1111H · Substantial damage NTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PAOct 7, 1973 · N90598 · Substantial damage NTSB NYC74DHA07Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAAug 24, 1973 · N1241S · Substantial damage NTSB NYC74FHA03Accident · No injuriesClosedSchweizer 126E · Kutztown, PAJul 30, 1973 · N17908 · Substantial damage NTSB NYC74DGT03Accident · No injuriesClosedGlasflugel H301 · Fairfield, PAJul 5, 1973 · N3943 · Minor damage NTSB NYC73FGT09Accident · No injuriesClosedSchleicher II · Fairfield, PAApr 22, 1973 · N7984 · Substantial damage NTSB NYC73DHD21Accident · No injuriesClosedSchweizer SG233A · West Chester, PAJan 6, 1973 · N7609 · Substantial damage NTSB NYC73DHA02Accident · No injuriesClosedSchweizer 233A · Erwinna, PAJul 15, 1972 · N1241S · Substantial damage NTSB NYC72DHA40Accident · No injuriesClosedSchleicher KA-6 · Kunkletown, PAJun 11, 1972 · N1510 · Substantial damage NTSB NYC71DHA18Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PASep 17, 1970 · N7543 · Substantial damage NTSB NYC70F0036Accident · No injuriesClosedSchweizer SGU222 · S Montrose, PAJul 15, 1969 · N91830 · Substantial damage NTSB NYC69D0037Accident · No injuriesClosedSchweizer SGS126 · Toughkenamon, PAJun 8, 1968 · N8683R · Substantial damage NTSB NYC68D0166Accident · No injuriesClosedSchweizer SGU222 · West Chester, PASep 11, 1967 · N9918J · Substantial damage