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 ('0420202')
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 ('0420202')
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 ERA20LA325Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe F 1 · West Kingston, RIThe pilot’s failure to conduct a proper preflight inspection and ensure the fuel was uncontaminated, which resulted in a partial loss of engine power and forced landing.NTSB SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB MIA97FA043Accident · 1 fatalField investigationFinal reportForney F-1 · Middleburg, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and an uncontrolled descent into a wooded area. Factors relating to the accident were: failure of the pilot to obtain a…NTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.NTSB LAX95LA022Accident · No injuriesLimited investigationFinal reportForney F-1 · Searchlight, NVthe pilot's failure to maintain directional control by improperly compensating for the existing wind conditions. The leaking cylinder, the prevailing crosswind, the soft terrain, and the dirt bank were factors in this accidentNTSB MIA93FA065Accident · 2 fatalField investigationFinal reportForney Ercoupe F-1 · Aguadilla, PRExcessive elevator control input by an unknown occupant at an airspeed above maneuvering speed which caused both forward wing spars to fail. Contributing to the accident was fuel exhaustion due to poor in flight planning/decision by the pilot-in-command and…NTSB FTW92LA128Accident · No injuriesLimited investigationFinal reportForney F-1 · Mason, TXThe pilot's delay in proceeding to a suitable alternate when his fuel state became questionable and his subsequent loss of control during the off airport precautionary landing. A factor was the gusty wind conditions on landing.NTSB ATL86LA152Accident · No injuriesLimited investigationFinal reportForney F-1 · Abbeville, SCThe student plt reported that the acft's brake system was inoperative during ldg rollout. The acft ran off the end of the rwy end into a trash pile and collided with pine logs.NTSB SEA84LA089Accident · No injuriesLimited investigationFinal reportFornaire F-1 · Everett, WAThe acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage.NTSB NYC83LA112Accident · No injuriesLimited investigationFinal reportForney F-1 · Fitchburg, MAThe acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…NTSB MIA81FA027Accident · 2 fatalClosedForney F-1 · Lakeland, FLNTSB DEN80FA030Accident · 1 fatalClosedForney F-1 · Ft.Collins, CONTSB IAD79FIJ10Accident · Serious injuriesClosedForney F-1 · Fayetteville, WVNTSB CHI79FEC18Accident · No injuriesClosedForney F-1 · Mason, MINTSB LAX77FUJ22Accident · Minor injuriesClosedForney F-1 · Phoenix, AZNTSB NYC74FGT18Accident · Minor injuriesClosedForney F-1 · Shippensburg, PANTSB MIA74FLD81Accident · Minor injuriesClosedForney F-1 · Sanford, FLNTSB DEN72DTC07Accident · Minor injuriesClosedForney F1 · Hulett, WYNTSB NYC70AN122Accident · 2 fatalClosedForney F-1A · Myerstown, PANTSB DEN70A0014Accident · 2 fatalClosedForney F-1 · Rancho Taos, NMNTSB UNK69X0116Accident · No injuriesClosedForney F-1 · St Eustatius (Atlantic Ocean)NTSB SEA68D0143Accident · No injuriesClosedForney F-1 · Jordan, MTNTSB LAX67D0361Accident · Minor injuriesClosedForney F-1 · Santa Paula, CANTSB CHI66F0570Accident · No injuriesClosedForney F-1 · W Lafayette, OHNTSB MKC66F0350Accident · Serious injuriesClosedForney F-1 · Burrton, KSNTSB UNK64X4007Accident · No injuriesClosedForney F1 · Red Bank, NJ
Back to Forney F-1