NTSB investigations: NONE, TX
4 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Undershoot”. 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
| 1983 | 1 |
|---|---|
| 1986 | 2 |
| 1993 | 1 |
Where
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\" = 'TX' 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\" = 390))
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" = 'TX' 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" = 390))
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 FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.NTSB FTW86LRA12Accident · No injuriesFinal reportMolino PIK-20B · College Station, TXThe glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area.NTSB FTW86LRG31Accident · No injuriesFinal reportRolladen-Schneider LS-6 · Uvalde, TXPilot of a Rolladen-Schneider LS-6 glider, N25SG, impacted terrain short of runway at Uvalde, TX airport. Pilot held U.S.-foreign private pilot certification based on german certification and was representing the aircraft manufacturer during glider…NTSB FTW83LA374Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26F · Caddo Mills, TXThe student plt saw a small thunderstorm moving toward the arpt, so he returned to land before it arrived. He stated he was 2 to 3 min too late. While in the traffic pattern, he encountered turbulence, downdrafts & winds reportedly gusting to 30 KTS. As the…