NTSB investigations: NONE, TX
9 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Hard landing”. 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 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 200))
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" = 200))
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 DFW05CA223Accident · Serious injuriesData collectionFinal reportAerostar International RX-8 · Denton, TXThe passenger's failure to follow landing instructions, which resulted in serious injury. A contributing factor was the high wind.NTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.NTSB FTW98LA014Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Caddo Mills, TXthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the gusty wind condition.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB FTW92LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Boerne, TXThe pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.NTSB FTW90LA122Accident · Serious injuriesLimited investigationFinal reportPiccard P-80 · Peaster, TXAn excessive rate of descent during the approach.NTSB FTW88LA167Accident · Serious injuriesLimited investigationFinal reportAdams A-60 · Austin, TXThe balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger.NTSB FTW84LA368Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · The Colony, TXThe plt reported that after takeoff, the wind picked up to about 12 to 15 KTS. She stated she made a normal high wind landing, but due to the angle of landing & position of the passenger's foot, her ankle broke during touchdown.NTSB FTW83LA155Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Springtown, TXThe balloon was on a 'hare & hound' competition flight with a commercial plt & student plt on board. After the competition portion was completed, the pilot-in-command told the student to take control & continue flying, then land at her discretion. After about…