Lycoming 0-340 series
NTSB investigations · 45
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 ('41510')
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 ('41510')
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 ANC26LA007Accident · No injuriesClass 4 · LimitedFinal reportDanchini Aero Danchini Cub · Wasilla, AKThe pilot’s inadequate preflight inspection, and inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing.NTSB CEN24LA151Accident · Serious injuriesClass 3 · LimitedFinal reportTemco D-16A · Clarksville, ARThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB ERA21LA030Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman AA5 · Baxley, GAA partial loss of engine power for undetermined reasons.NTSB CEN14CA343Accident · Minor injuriesData collectionFinal reportCessna 170B · Tomball, TXThe pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.NTSB CEN14LA290Accident · Serious injuriesLimited investigationFinal reportTeunis Starduster TOO SA300 · Fort Worth, TXThe non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.NTSB WPR13LA125Accident · Minor injuriesLimited investigationFinal reportTemco D-16A · Heber, CAA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight and fuel planning.NTSB CEN10CA175Accident · No injuriesData collectionFinal reportVan Dusen John M Longeze · Houston, TXThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB CEN10LA004Accident · Serious injuriesLimited investigationFinal reportTemco D-16A · Eden Prairie, MNA total loss of left engine power due to fuel starvation as a result of the failure of the engine's electric fuel pump end cap gasket, which allowed air to be drawn into the fuel system.NTSB ERA09LA420Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Fort Pierce, FLA loss of engine power due to fuel starvation as a result the failure of the engine fuel pump diaphragms during climb.NTSB SEA07CA032Accident · No injuriesData collectionFinal reportRiley D-16A · Point Roberts, WAthe pre-existing crack in the nose wheel fork, which allowed separation of the nose wheel during the takeoff roll, resulting in collapse of the nose landing gear.NTSB ANC03LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.NTSB ANC02LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe separation of the right main landing gear from the airplane during landing. A factor associated with the accident is the unapproved hardware used to attach the main landing gear.NTSB ANC01LA128Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's inadvertent stall/mush during the initial climb after takeoff, and subsequent in-flight collision with a tree.NTSB MIA00WA002Accident · No injuriesForeign investigationTemco DA-16A · Freeport, BahamasNTSB IAD97LA110Accident · No injuriesLimited investigationFinal reportCessna 170B · Jamestown, NYThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB NYC96LA176Accident · Serious injuriesLimited investigationFinal reportTemco D-16A · Hainesport, NJthe pilot's improper inflight planning/decision and inadequate management of fuel, which resulted in fuel exhaustion and the loss of engine power.NTSB MIA96LA081Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Miami, FLFailure of the pilot to maintain proper runway alignment during a go-around, resulting in a collision with trees beside the runway. The crosswind was a related factor.NTSB SEA96LA030Accident · No injuriesLimited investigationFinal reportCessna 170B · John Day, ORThe pilot's failure to maintain a proper glidepath.NTSB MIA95LA092Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Opa Locka, FLCollapse of the tailwheel gear assembly, due to improper installation of a nut by maintenance personnel.NTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.NTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…NTSB FTW85FA014Accident · 4 fatalField investigationFinal reportPiper PA-23-170 · Seguin, TXShortly after takeoff, acft returned with an unknown engine problem. Left engine was feathered and gear partially extended. Acft too high on final to land, acft continued down rwy, descending and slowing down. Witness said acft entered a VMC roll and dove…NTSB ATL82LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-170 · Tuscaloosa, ALDuring an instructional flight the right engine was shut down and the prop feathered after a vibration was felt. The flight continued to its intended destination. Witnesses stated that they observed the right prop rotating while on final approach, even though…NTSB ANC79DAG42Accident · No injuriesClosedCessna 170B · Montague Is, AKNTSB DEN79FA002Accident · 2 fatalClosedGrum Amer AA5 · Littleton, CONTSB IAD77DKM26Accident · No injuriesClosedGrum Amer AA5 · Rutherfordton, NCNTSB LAX75FUJ82Accident · No injuriesClosedGrum Amer AA-5 · Scottsdale, AZNTSB CHI75FEE36Accident · No injuriesClosedTemco D16A · Hebron, ILNTSB ANC74DAH09Accident · No injuriesClosedCessna 170B · Anchorage, AKNTSB FTW74FPD33Accident · No injuriesClosedPiper PA-22 · Alvord, TXNTSB FTW74FRD06Accident · No injuriesClosedAmer Avco AA-5 · Westwego, LANTSB FTW73DRJ41Accident · No injuriesClosedAmer Avco AA-5 · Zwolle, LANTSB MIA69F0330Accident · No injuriesClosedTwin Navion D-16A · Cookeville, TNNTSB CHI69F0502Accident · No injuriesClosedTemco D16A · Crown Point, INNTSB MIA69D0215Accident · No injuriesClosedTemco D-16A · Freeport, Burkina FasoNTSB FTW69D0088Accident · Minor injuriesClosedTemco D-16A · Mineral Wells, TXNTSB NYC68F0112Accident · Minor injuriesClosedTemco D-16A · Wayne, NJNTSB SEA68D0043Accident · No injuriesClosedCessna 170B · Elgin, ORNTSB DIA67F0098Accident · No injuriesClosedTemco D-16A · Hassell, NCNTSB LAX67D0343Accident · No injuriesClosedPiper PA-23 · Oceanside, CANTSB DEN67F0135Accident · No injuriesClosedPiper PA-23 · Sterling, CONTSB CHI67D0213Accident · No injuriesClosedTemco D-16 · Waukegan, ILNTSB SEA67D0069Accident · No injuriesClosedTemco D-16 · Seattle, WANTSB MIA66D0488Accident · No injuriesClosedTemco D-16A · Jackson, MSNTSB CHI66D0392Accident · No injuriesClosedCessna 170B · Dalton, OH
Back to Lycoming 0-340 series