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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('89510T7', '89510T8', '89510T3', '89510TC', '89510TD', '89510TF', '89510UB', '89510S7', '89510S8', '89510TA', '89510TB', '89510TE', '89510TJ', '89510TU', '89510TZ', '89510UC', '89510S6', '89510TG', '89510TH', '89510TM', '89510TP', '89510TX', '89510TY')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('89510T7', '89510T8', '89510T3', '89510TC', '89510TD', '89510TF', '89510UB', '89510S7', '89510S8', '89510TA', '89510TB', '89510TE', '89510TJ', '89510TU', '89510TZ', '89510UC', '89510S6', '89510TG', '89510TH', '89510TM', '89510TP', '89510TX', '89510TY')
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 WPR16LA023Accident · No injuriesLimited investigationFinal reportThorp T 18 · Independence, ORA separation of the canopy mechanism during flight, which resulted in the pilot’s precautionary landing and the airplane’s subsequent collision with a fence post.NTSB CEN12LA566Accident · Serious injuriesLimited investigationFinal reportThorp T-18 · Gilmer, TXThe disconnected metering unit fuel line, which resulted in a loss of engine power.NTSB SEA08LA127Accident · 1 fatalLimited investigationFinal reportThorp T-18 · Kent, WAThe loss of engine power for undetermined reasons. Contributing to the accident were the lack of a suitable landing area and the pilot's failure to maintain an adequate airspeed while maneuvering in response to the loss of engine power.NTSB SEA07CA185Accident · Minor injuriesData collectionFinal reportHammer Thorp T-18 · Everett, WAExcessive airspeed during a return for landing which resulted in an overrun. An unlatched canopy, a proper touchdown point not attained and rough terrain were factors.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.NTSB LAX89DUJ05Accident · Serious injuriesFinal reportWarwick Thorp T-18 · Aguila, AZFailure of the pilot to maintain directional control, which resulted in the aircraft veering off the runway. Factors related to the accident were: uneven runway & the ditch.NTSB FTW85LA127Accident · Serious injuriesLimited investigationFinal reportThorpe T-18 · Ada, OKThe aircraft had been stored for 8 months with automotive fuel in the tank. During takeoff, the eng lost power. Subsequently, the plt lost control & the acft impacted the ground at a 45 deg angle. An investigation revealed that softened tank sealant material…NTSB NYC80FHA18Accident · 2 fatalClosedThorp T-18 · Quakertown, PANTSB SEA79FYP21Accident · Serious injuriesClosedThorp T-18 · Zillah, WANTSB FTW78DPG89Accident · No injuriesClosedThorp T-18 · N.Little Rock, ARNTSB CHI78DEP48Accident · Minor injuriesClosedThorp T18 · Kenosha, WINTSB LAX77FUQ39Accident · 1 fatalClosedThorp T-18 · Van Nuys, CANTSB DEN77DQA06Accident · No injuriesClosedThorp T18 · Santa Fe, NMNTSB CHI75FEM28Accident · Serious injuriesClosedThorp T-18 · Lansing, MINTSB FTW73FPA33Accident · Serious injuriesClosedThorp T-18 · Whitesboro, TXNTSB MKC73FCG46Accident · No injuriesClosedThorp T-18 · Ozark, MONTSB MIA72FLG37Accident · Minor injuriesClosedParks Thorp T-18 · St.Matthews, SCNTSB DEN72FTM11Accident · 1 fatalClosedThorp T-18 · Kearns, UTNTSB OAK70FVA14Accident · 2 fatalClosedThorpe T-18 · Huntington Lk, CANTSB SEA70D0023Accident · Minor injuriesClosedThorp T-18 · Puyallup, WANTSB MKC68F0273Accident · Minor injuriesClosedThorp T-18 · Anoka, MNNTSB OAK67D0331Accident · No injuriesClosedThorp T-18 · Lone Pine, CA
Back to Thorp T-18