Skip to content

NTSB investigations: NONE, TN

29 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 per year

19702026

Where

Latest cases

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" = 'TN' 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\" = 'TN' 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" = 'TN' 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 ERA23LA115Accident · Minor injuriesClass 4 · LimitedFinal reportEiriavion PIK-20D · Benton, TNThe pilot’s decision to turn toward a mountain ridge in a thermal, which resulted in a collision with terrain.Jan 20, 2023 · N1NZ · Substantial damage NTSB ERA17LA243Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B 15 · Murfreesboro, TNThe passenger's failure to let go of the balloon's gondola when the balloon began to ascend. Contributing to the accident was the pilot's failure to maintain control of the balloon after landing, which resulted in an inadvertent takeoff.Jul 15, 2017 · N3282P · No damage NTSB GAA16CA479Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Benton, TNThe glider pilot's descent below the glidepath and the subsequent hard, off-airport landing.Sep 4, 2016 · N27BZ · Substantial damage NTSB ERA14CA215Accident · Serious injuriesData collectionFinal reportSchleicher Alexander K 7 · Benton, TNThe pilot's distraction with traffic on the runway, and his subsequent failure to retract the air brakes prior to touchdown, which resulted in a hard landing.Apr 27, 2014 · N1002Z · Minor damage NTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.Jun 28, 2012 · N273BA · Substantial damage NTSB ERA12CA321Accident · Serious injuriesData collectionFinal reportEiriavion PIK 20D · Eagleville, TNThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.May 6, 2012 · N39RB · Substantial damage NTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.Oct 14, 2011 · N1339X · Substantial damage NTSB ERA11CA206Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Winchester, TNThe glider pilot's delayed response to changing weather conditions, which resulted in an off-airport landing into trees.Mar 24, 2011 · N1359 · Substantial damage NTSB ERA10CA176Accident · No injuriesData collectionFinal reportRolladen-Schneider LS-4 · Jasper, TNThe inadequate in-flight planning by the glider pilot to intentionally cross a ridge at low altitude, resulting in the in-flight collision with trees.Mar 15, 2010 · N465CB · Substantial damage NTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.Aug 23, 2009 · N504BT · Substantial damage NTSB ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.Sep 28, 2002 · N8747 · Substantial damage NTSB ATL02LA027Accident · No injuriesLimited investigationFinal reportFlugzeugbau DG-200 · Benton, TNThe pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.Dec 29, 2001 · N5457T · Substantial damage NTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.Feb 21, 1998 · N25MZ · Substantial damage NTSB MIA97LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Benton, TNThe failure of the pilot to maintain altitude and clearance from the trees on a ridge line.Mar 20, 1997 · N33WP · Substantial damage NTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.Oct 30, 1996 · N15CB · Substantial damage NTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…Aug 25, 1988 · N795 · Substantial damage NTSB ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…Jun 29, 1988 · N9807N · No damage NTSB ATL88LA120Accident · Serious injuriesLimited investigationFinal reportSlingsby Dart T-51 · Whitwell, TNThe glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull…Mar 20, 1988 · N209K · Destroyed NTSB ATL86LA262Accident · No injuriesLimited investigationFinal reportAlexander AS-K13 · Tullahoma, TNDuring an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high…Sep 20, 1986 · N6877 · Substantial damage NTSB ATL85LLT07Accident · Serious injuriesFinal reportBarnes FF-7 · Franklin, TNThe plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…May 8, 1985 · N4049Y · Minor damage NTSB ATL83LA243Accident · No injuriesLimited investigationFinal reportSchleicher AS-K13 · Tullahoma, TNThe pilot stated that his approach was too fast and he bounced the acft during the landing. The glider drifted left and collided with a hayroll. The collision caused another swerve and a subsequent collision with another hayroll.Jun 25, 1983 · N6877 · Substantial damage NTSB IAD80FKW06Accident · No injuriesClosedSchweizer 1-26E · Benton, TNJan 19, 1980 · N2994H · Substantial damage NTSB IAD80FKW04Accident · Serious injuriesClosedRaven S55A · Knoxville, TNJan 3, 1980 · N8542L · No damage NTSB IAD79FKW14Accident · No injuriesClosedSchleicher KA8B · Benton, TNMay 26, 1979 · N170DR · Destroyed NTSB IAD78FKW09Accident · Minor injuriesClosedLet-Np-K L-13 · Benton, TNAug 2, 1978 · N96AS · Substantial damage NTSB IAD77DKW30Accident · No injuriesClosedSchleicher KA6CR · Benton, TNSep 4, 1977 · N201V · Minor damage NTSB IAD77DLT03Accident · No injuriesClosedRaven RX6 · Huntingdon, TNApr 10, 1977 · N1035R · Substantial damage NTSB IAD75DKW22Accident · No injuriesClosedBlanik L-13 · Benton Tn, TNJun 9, 1975 · N90639 · Substantial damage NTSB MIA71FKW24Accident · Serious injuriesClosedSchweizer TG-3A · Eagleville, TNDec 5, 1970 · N63904 · Substantial damage