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.engine_model_code IN ('35005')
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.engine_model_code IN ('35005')
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 ERA23LA318Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Laconia, NHThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane, which resulted in a ground-loop.NTSB GAA20CA070Accident · No injuriesData collectionFinal reportCessna 195 · Kalispell, MTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.NTSB WPR17LA058Accident · No injuriesLimited investigationFinal reportBeech E17L · Discovery Bay, WAA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.NTSB ERA09CA006Accident · No injuriesData collectionFinal reportBeech F17D · Moscow, TNThe mechanical failure of the landing gear actuation chain.NTSB DEN08CA148Accident · No injuriesData collectionFinal reportRobinson R-22 · Refugio, TXThe pilot failed to maintain adequate airspeed while maneuvering to land.NTSB CHI06CA113Accident · No injuriesData collectionFinal reportCessna 195 · Pine Creek, MNThe pilot's improper flare and improper recovery from a bounced landing.NTSB MIA06LA041Accident · 3 fatalLimited investigationFinal reportCessna 195 · St. Augustine, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.NTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.NTSB CHI03LA177Accident · No injuriesLimited investigationFinal reportWaco ARE · Battle Creek, MIThe inadequate material used in the landing gear cross supports leading to its collapse during the landing roll.NTSB LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.NTSB DEN00LA154Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Ogden, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were a tail wind, inadequate weather evaluation by the pilot, and lack of experience in make and model.NTSB FTW95LA328Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe inadvertent stall as a result of the pilot's failure to maintain airspeed during the approach.NTSB FTW94LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe total loss of engine power due to water contamination of the fuel system. A factor was the lack of suitable terrain available to the pilot for the forced landing and his inadequate preflight inspection.NTSB BFO92LA118Accident · Minor injuriesLimited investigationFinal reportWaco AVN-8 · Hamilton, OHThe pilot misjudged distance and altitude which resulted in a landing overrun.NTSB MKC88LA080Accident · No injuriesLimited investigationFinal reportBeech F17D · Perryville, MODuring the landing phase of operation, the propeller struck the runway several times prior to the acft making a gear up ldg. After the acft came to a stop, a post flight fire erupted destroying the acft. Evidence of gear up landing was confirmed after post…NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…NTSB CHI83LA431Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Hamilton, OHThe plt reported that he encountered gusty x-winds on final apch. According to him, a quartering tail wind was encountered after touchdown which pushed the acft on its nose. The acft skidded on its nose until it contacted sod at the edge of the rwy, then…NTSB LAX83FVM02Accident · Minor injuriesFinal reportBeech F17D · Hollister, CAThe eng quit immediately after takeoff & the acft landed in an orchard. The fuel selector was found on the empty fuselage tank. The left wing auxillary tank was empty & the right wing auxillary tank was approximately full.NTSB OAK76FVG61Accident · No injuriesClosedCessna 195A · Sloughhouse, CANTSB LAX76FUA07Accident · No injuriesClosedCessna 195 · S.Juan Cpstrno, CANTSB LAX75DUJ65Accident · No injuriesClosedCessna 195 · Taylor, AZNTSB FTW74DPG60Accident · No injuriesClosedGrumman G-164 · Carlisle, ARNTSB DEN73DTE64Accident · No injuriesClosedCessna 195A · La Salle, CONTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NENTSB LAX71FUQ80Accident · Minor injuriesClosedBeech E17L · San Frnando, CANTSB LAX71DUG36Accident · No injuriesClosedCessna 195 · Upland, CANTSB CAN69ACAIOAccident · 1 fatalClosedCessna 195 · Flat Lake, CanadaNTSB FTW67F0570Accident · No injuriesClosedGrumman G-164 · Church Point, LANTSB MKC67D0161Accident · No injuriesClosedCessna 195 · Dunseith, NDNTSB MIA67F0134Accident · No injuriesClosedBeech G17S · Atlanta, GANTSB FTW66F0356Accident · No injuriesClosedCessna 195 · Odessa, TXNTSB SEA66D0111Accident · No injuriesClosedWaco YKS-7 · Klamath Falls, ORNTSB MKC66F0045Accident · No injuriesClosedBeechcraft F-17D · Papillion, NENTSB MKC65F0067Accident · No injuriesClosedCessna 195A · Aberdeen, SDNTSB UNK64X4111Accident · No injuriesClosedCessna 195A · Tallahassee, FLNTSB UNK64X2093Accident · No injuriesClosedCessna 170A · Durango, CONTSB UNK64X1707Accident · No injuriesClosedCessna 195 · Wheeling, ILNTSB UNK64X0465Accident · No injuriesClosedWaco AGC8 · Marquetta, MINTSB UNK64X0223Accident · No injuriesClosedBeechcraft F17D · Battle Mt, NV
Back to Jacobs L6