NTSB investigations: NONE, TX
11 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with object”. 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 |
|---|---|
| 1989 | 3 |
| 1990 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
Where
Open the mapLatest 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\" = 220))
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" = 220))
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 DFW05CA075Accident · No injuriesData collectionFinal reportSchweizer SGS1-26B · Midlothian, TXThe pilot's misjudgment in distance/altitude and his failure to maintain clearance from a tree while on final to approach to landing. Contributing factors were the lack of thermal lift and the gusty wind conditions.NTSB FTW04CA234Accident · No injuriesData collectionFinal reportLindstrand Balloons 90A · Allen, TXThe pilot's failure to maintain clearance with the power lines. A contributing factor was the gusty wind conditions.NTSB FTW02LA270Accident · Serious injuriesLimited investigationFinal reportRaven S60A · La Vernia, TXThe pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.NTSB FTW01LA213Accident · Serious injuriesLimited investigationFinal reportCameron Balloon N-77 · McKinney, TXthe pilot's failure to maintain clearance with the fence while landing. A contributing factor was the high wind condition.NTSB FTW99LA238Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103C · San Antonio, TXThe pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.NTSB FTW96LA242Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · San Angelo, TXfailure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.NTSB FTW90LA110Accident · Serious injuriesLimited investigationFinal reportAdams A60S · Austin, TXImproper planning/decision by the pilot. The unfavorable wind and obstacles were related factors.NTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.NTSB FTW89FA081Accident · Serious injuriesField investigationFinal reportHead Balloons AX8-88 · Troy, TXImproper planning/decision by the pilot, and inadequate supervision by the check pilot, which resulted in their failure to maintain clearance from the tree during the landing. Factors related to the accident were: the high wind & tree(s).NTSB FTW83FA364Accident · No injuriesField investigationFinal reportBalloon Works Firefly AX-7 · Fort Worth, TXThe intended landing area was a parking lot. Adjacent to the lot was a one-story building on top of which a tv antenna about 20 ft above the roof top. In an effort to clear the antenna during the descent to the parking lot, the pltwas not aware of a set of…