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 ('7100604')
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 ('7100604')
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 CEN23LA378Accident · No injuriesClass 4 · LimitedFinal reportPiper J4 · Cleburne, TXThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions.NTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.NTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.NTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB NYC02LA077Accident · No injuriesLimited investigationFinal reportPiper J4A · Cincinnati, OHThe maintenance technician's failure to properly adjust the carburetor float. Factors were the unsuitable terrain.NTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.NTSB FTW94LA215Accident · No injuriesLimited investigationFinal reportPiper J4A · Granite Shoals, TXFuel system starvation due to the pilot's failure to secure the engine fuel primer. A factor was the lack of suitable terrain for the forced landing.NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB FTW85LA328Accident · No injuriesLimited investigationFinal reportPiper J4A · Duncan, OKThe plt was practicing short fld landings when the accident occurred. He stated the acft ballooned and he advanced the throttle but the eng failed to respond immediately. The acft stalled at 2 ft above the ground according to the plt. Hardcontact with the…NTSB NYC84FNE03Accident · 1 fatalFinal reportPiper J4A · Gardner, MADuring climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…NTSB CHI83LA099Accident · Minor injuriesLimited investigationFinal reportPiper J-4 · Chesterville, OHShortly after takeoff, the engine lost power. The pilot tried to turn back and land on the departure airstrip, but did not have enough altitude. While trying to land, he pulled the plane up to cross over transmission lines. However, the plane collided with…NTSB CHI81FER50Accident · No injuriesClosedPiper J4A · Elgin, MNNTSB NYC77DHA34Accident · Serious injuriesClosedPiper J4A · Stillwater, NJNTSB FTW77FPA19Accident · Serious injuriesClosedPiper J4A · Allen, TXNTSB IAD75FKM17Accident · No injuriesClosedPiper J4 · Advance, NCNTSB LAX75DUG10Accident · No injuriesClosedPiper J4A · Upland, CANTSB OAK74DVM03Accident · No injuriesClosedPiper J4A · San Jose, CANTSB NYC73AN127Accident · 1 fatalClosedPiper J4A · Pennington, NJNTSB MKC73DCQ07Accident · No injuriesClosedPiper J4A · Beaumont, KSNTSB SEA72FYA21Accident · Minor injuriesClosedPiper J4A · Boise, IDNTSB CHI72FEA03Accident · Minor injuriesClosedPiper J4A · Cloverdale, INNTSB OAK71DVA91Accident · Minor injuriesClosedPiper J4A · Three Rivrs, CANTSB MKC71FCD79Accident · Serious injuriesClosedPiper J4-A · Clear Lake, IANTSB MIA70D0138Accident · No injuriesClosedPiper J-4A · Lawtey, FLNTSB LAX70F0073Accident · 1 fatalClosedPiper J4A · Ramona, CANTSB NYC70D0136Accident · Minor injuriesClosedPiper J4 · Medina, NYNTSB LAX68D0393Accident · No injuriesClosedPiper J4A · Santee, CANTSB NYC68F0495Accident · No injuriesClosedPiper J-4 · Berlin, NJNTSB DIA68D0114Accident · No injuriesClosedPiper J4A · Jeffersonton, VANTSB CHI68F0110Accident · No injuriesClosedPiper J-4 · Galesburg, MINTSB OAK67D0168Accident · No injuriesClosedPiper J4A · Orland, CANTSB MIA67D0227Accident · No injuriesClosedPiper J4A · Warner Robins, GANTSB SEA67F0143Accident · No injuriesClosedPiper J4 · Homedale, IDNTSB OAK66A0041Accident · 2 fatalClosedPiper J4 · Healdsburg, CANTSB MIA66F0346Accident · 1 fatalClosedPiper J4A · Greenville, MSNTSB OAK65F0007Accident · No injuriesClosedPiper J4 · Madera, CANTSB UNK65X1371Accident · No injuriesClosedPiper J4A · Bastrop, LANTSB UNK64X2860Accident · Minor injuriesClosedPiper J4A · Van Wert, OH
Back to Piper J4A