Warner SS40&50
NTSB investigations · 41
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 ('64503')
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 ('64503')
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 WPR26LA059Accident · No injuriesClass 4 · LimitedFinal reportWaco RNF · Phoenix, AZThe biplane pilot’s failure to maintain adequate clearance from the low-wing airplane while taxiing.NTSB CEN24LA007Accident · Minor injuriesClass 4 · LimitedFinal reportFairchild 24 G · Peyton, COThe pilot’s excessive brake application during landing rollout led to the airplane nosing over.NTSB GAA23WA263Accident · No injuriesClass 5 · ForeignFairchild 24 G · Trier-Föhren, GermanyNTSB GAA16CA190Accident · No injuriesData collectionFinal reportMonocoupe 110 · Chandler, AZThe pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.NTSB CEN09CA346Accident · No injuriesData collectionFinal reportMeyers OTW · Haskell, TXThe pilot's failure to maintain directional control while landing in a crosswind.NTSB LAX07CA010Accident · No injuriesData collectionFinal reportMonocoupe 110 Special · Chandler, AZthe failure of the forward left main landing gear attach point resulting in loss of control.NTSB DFW06LA078Accident · 1 fatalLimited investigationFinal reportCessna C-37 · Fittstown, OKThe loss of engine power due to a cracked cylinder head. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW04LA102Accident · No injuriesLimited investigationFinal reportWaco RBA · Temple, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the locked wheel.NTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…NTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.NTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.NTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.NTSB CHI96LA001Accident · No injuriesLimited investigationFinal reportLuscombe Phantom 1 · Rolla, MOmechanical failure of the left brake.NTSB CHI95LA333Accident · Minor injuriesLimited investigationFinal reportFairchild FA-24 · Blountsville, INpartial loss of engine power for an undetermined reason, and the pilot's improper in-flight planing/decision. Factors relating to the accident were: the pilot's misuse of flaps, and his encounter with high obstruction during the forced landing.NTSB MIA95LA203Accident · Serious injuriesLimited investigationFinal reportFairchild 24-G · Harold, FLThe engine missing for undetermined reasons, and the failure of the pilot in command to maintain airspeed while turning toward a landing area.NTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceNTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.NTSB FTW91LA004Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Lampasas, TXThe failure of a cylinder intake valve spring.NTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.NTSB LAX89LA232Accident · No injuriesLimited investigationFinal reportRyan SCW-145 · Santa Paula, CATotal loss of engine power for undetermined reasons.NTSB LAX85LA302Accident · No injuriesLimited investigationFinal reportMeyers OTW · Winters, CAThe purpose of this flt was to check out a commercial plt in the acft. Dual flt controls & heel brakes were installed. The student was practicing landings & on his 4th or 5th landing roll, the acft began to turn to the right. The student applied left rudder &…NTSB SEA84LA160Accident · Minor injuriesLimited investigationFinal reportRearwin Rearwin 8125 · The Dalles, ORThe plt inadvertantly taxied the acft to the wrong rwy for takeoff. The plt did say he saw acft departing from another rwy. Takeoff was attempted with a 19 kt x-wind. The acft ran off the side of the rwy before becoming airborne. The arpt manager has since…NTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.NTSB DCA83AA030Accident · Minor injuriesFinal reportMeyers OTW · Woodbridge, VAWhile en route at an altitude of aprx 2000 ft MSL, the plt noticed a definite loss of power & RPM, which was followed by a loss of oil pressure. He reversed course intending to land at an arpt that he had passed. A clattering noise was heard in the eng, which…NTSB MIA78FKG30Accident · No injuriesClosedCessna C-145 · Chamblee, GANTSB MIA77DA066Accident · 2 fatalClosedDavis D-1-W · Camden, SCNTSB MKC76FCG73Accident · No injuriesClosedMonocoupe D-145 · Grain Valley, MONTSB DEN74DTC27Accident · No injuriesClosedWaco RNF · Gillette, WYNTSB MIA73DLD23Accident · No injuriesClosedWaco RNF · Palma Sola, FLNTSB MKC71DDM03Accident · No injuriesClosedCessna C-34 · Pennock, MNNTSB LAX70FUQ31Accident · No injuriesClosedMonocoupe 90 · Newhall, CANTSB CHI70FBA11Accident · No injuriesClosedLuscombe 1 · Noblesville, INNTSB MKC70F0153Accident · No injuriesClosedMeyers OTW · Ottumwa, IANTSB DIA69F0081Accident · Minor injuriesClosedDavis D-1-W · Gastonia, NCNTSB CHI66F0359Accident · No injuriesClosedFairchild 24G · Joliet, ILNTSB OAK65F0073Accident · No injuriesClosedCessna C-37 · Gustine, CANTSB UNK65X1261Accident · No injuriesClosedFairchild 24W41A · Norwood, MANTSB UNK65X0326Accident · Minor injuriesClosedCurtis-Wght 12W · Gadsden, ALNTSB UNK65X0190Accident · Minor injuriesClosedCessna C37 · Shawnee, OKNTSB UNK64X3749Accident · No injuriesClosedFairchild 24J · Ottumwa, IANTSB UNK64X1294Accident · 2 fatalClosedFairchild 24C-8E · Wapato, WA
Back to Warner SS40&50