Ford CONVERSION
NTSB investigations · 29
Matched to the registry by N-number and event date, newest first.
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 ('26701')
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 ('26701')
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 CEN27LA017AccidentClass 3 · LimitedInvestigation openDonald K Stovall Pietenpol Aircamper · Syracuse, KSNTSB ERA25LA183Accident · Serious injuriesClass 4 · LimitedFinal reportFrank Lowell C Pietenpol · Taylorsville, NCThe pilot’s failure to maintain control of the airplane during an attempted go around in gusty tailwind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB CEN23LA372Accident · No injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Hanover, ILThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during an attempted forced landing at low altitude. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB CEN23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Gardner, KSA loss of engine power due to lead fouling of a spark plug.NTSB CEN19LA306Accident · Serious injuriesClass 3 · LimitedFinal reportPietenpol Sky Scout · Kingsbury, TXThe total loss of engine power for reasons that could not be determined with the available evidence and the pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and spin at a low altitude.NTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.NTSB WPR14FA174Accident · 1 fatalField investigationFinal reportHawker SEA Fury TMK 20 · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.NTSB CEN12LA288Accident · No injuriesLimited investigationFinal reportDonald K Stovall Pietenpol Aircamper · Rose Hill, KSThe loss of engine power due to carburetor icing.NTSB WPR09LA047Accident · Serious injuriesLimited investigationFinal reportNickel RV-6 · Fresno, CAThe loss of engine power during initial climb for undetermined reasons.NTSB LAX08CA295Accident · Minor injuriesData collectionFinal reportMiltenberger Family Fun · Adin, CAThe loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB DFW07CA175Accident · Minor injuriesData collectionFinal reportMellema Bede 4 · Ennis, TXThe pilot's inability to maintain control of the airplane following the disconnect of the tailwheel steering chain while landing.NTSB LAX07CA181Accident · No injuriesData collectionFinal reportDutton Air Camper · Atwater, CAa loss of power due to the failure of the number 2 connecting rod.NTSB IAD05LA070Accident · Minor injuriesLimited investigationFinal reportSnyder Sky Scout · Round Lake, NYA loss of engine power for undetermined reasons. A factor was the soft field.NTSB FTW01LA199Accident · No injuriesLimited investigationFinal reportJohn Greenlee X-Aircamper · Healdton, OKThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat during the approach to land. Contributing factors were weather conditions conducive to carburetor icing conditions and the lack of suitable terrain for…NTSB CHI01LA022Accident · Minor injuriesLimited investigationFinal reportBollinger BD-4 · Hedrick, IAthe pilot not obtaining/maintaining clearance from the fence. A factors was fence.NTSB NYC99LA184Accident · No injuriesLimited investigationFinal reportTroy Pietenpol · Collins, OHIn-flight separation of the propeller.NTSB MIA97LA052Accident · 1 fatalLimited investigationFinal reportSirocco Flying Club MJ 5 · Sanford, FLfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern (crosswind) after takeoff, which resulted in an inadvertent stall, uncontrolled descent, and collision with terrain.NTSB LAX96LA141Accident · Minor injuriesLimited investigationFinal reportScheperle Mustang II MOD · Merced, CAa loss of engine power due to a malfunctioning thermostat valve in the liquid cooling system.NTSB IAD96LA051Accident · No injuriesLimited investigationFinal reportMulholland Witchawk · Celina, OHthe pilot's selection of unsuitable terrain for a precautionary landing.NTSB CHI95LA284Accident · No injuriesLimited investigationFinal reportVan Zwoll Viking · Decker, INthe failure of the head gasket resulting in a coolant leak and subsequent engine overtemperature. A factor was the unsuitable terrain encountered in the cornfield.NTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.NTSB FTW87DQG01Accident · No injuriesFinal reportReplica P51 · Midland, TXPilot reported prop surging in flt. During landing roll the pilot lost control, groundlooped and the main landing gear collapsed. Investigation could not reveal a reason for the prop surging.NTSB SEA86LA149Accident · No injuriesLimited investigationFinal reportMellema Bede 4 · Kent, WAThe engine ceased operating 10 feet a.g.l. during takeoff while on a biennial flight review. A landing straight ahead was made onto the runway, but in order to avoid an overrun an intentional ground loop was made. On engine examination a large bug was found…NTSB ATL86FEK02Accident · Serious injuriesFinal reportGreen Pietenpol · Mt. Vernon, OHThe acft stalled and entered a spin to ground impact during the initial takeoff climb. The plt reported that during the takeoff and climb the airspeed indicator did not exceed 40 mph. He also stated the acft did not appear to be traveling very fast. He then…NTSB FTW86LQG15Accident · No injuriesFinal reportAviation ADV. Mustang Psid · Midland, TXThe experimental acft on a test flt suffered an engine failure during the final approach to land. The plt said that he did not believe he could make the arpt so he turned right to an open field to land downwind. Investigation after the accident revealed that…NTSB DEN85FTM06Accident · Minor injuriesFinal reportMitchell/Bede BD-4 · Woods Cross, UTThe acft crashed after the eng quit during takeoff. The acft hit the ground off the arpt in a left descending bank which collapsed the left lndg gear. Investigation revealed corrosion of the carburetor float bowl. The plt was using auto fuel. The fuel tanks…NTSB MKC83FA167Accident · Serious injuriesField investigationFinal reportPietenpal AIR Camper · Saint Ansgar, IAThe acft crashed following tkof from an enroute stop during a x-country flt. The plt's friend witnessed the takeoff. The witness said the plt waved after takeoff and then the acft made a sharp left bank with wings waggling. The acft rolled level and entered…NTSB CHI79FEE17Accident · 1 fatalClosedHawker TMK20 · Waukegan, IL
Back to Ford CONVERSION