Skip to content

Final NTSB investigations: Warner SCARAB series

15 cases on aircraft whose registry engine model is Warner SCARAB series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64502')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64502'))
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA25LA055Accident · No injuriesClass 4 · LimitedFinal reportBrunner-Winkle Bird A · Senoia, GAThe pilot’s improper flare, which resulted in a hard landing, and landing gear collapse.Nov 17, 2024 · N15641 · Substantial damage NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.Apr 6, 2012 · N14722 · Substantial damage NTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.Sep 15, 2007 · N110SP · Destroyed NTSB LAX07CA097Accident · Minor injuriesData collectionFinal reportMonocoupe 110 · Camarillo, CAThe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.Mar 1, 2007 · N18642 · Substantial damage NTSB ATL06CA034Accident · No injuriesData collectionFinal reportLabarre Hatz CB1 · Walhalla, SCThe pilot's selection of unsuitable terrain to land. Contributing factors were the wet, soft, grassy runway.Jan 11, 2006 · N86LL · Substantial damage NTSB SEA98LA151Accident · No injuriesLimited investigationFinal reportCurtiss-Wright 12W · Woodland, WAThe pilot in command misjudged clearance from high vegetation when he landed. Factors include inadequate mowing of high vegetation by airport personnel, providing insufficient clearance for the wingspan of landing airplanesJul 26, 1998 · N11715 · Substantial damage NTSB LAX97LA192Accident · Minor injuriesLimited investigationFinal reportCrosby GEE BEE Sportster · Watsonville, CAan unknown failure of the engine oil system, which resulted in loss of oil and a seized engine.May 23, 1997 · N11044 · Substantial damage NTSB ATL96LA013Accident · No injuriesLimited investigationFinal reportFleet ONE · Holly Springs, NCa loss of engine power due to a cracked crankshaft. A factor was the rough/uneven terrain encountered during the forced landing.Nov 19, 1995 · N638M · Substantial damage NTSB DEN90LA067Accident · Minor injuriesLimited investigationFinal reportHeindenreich Fokker DR-1 · Kalispell, MTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. His lack of familiarity with this aircraft was a related factor.Feb 23, 1990 · N72517 · Substantial damage NTSB ATL84LA188Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Danville, VAThe pilot was en route to NJ when the eng began to run rough. He diverted to Danville, VA, and landed. During the subsequent takeoff the eng began to run rough, then quit at an alt of aprx 700 feet. The pilot turned the acft and over flew the departure rwy to…May 25, 1984 · N11254 · Substantial damage NTSB OAK76DVM48Accident · No injuriesClosedSchlemeyer · Portola Valley, CASep 30, 1976 · N713S · Substantial damage NTSB NYC73FFJ01Accident · No injuriesClosedFokker DR1 · Kirkville, NYJul 8, 1972 · N2203 · Substantial damage NTSB SEA70D0109Accident · No injuriesClosedMonocoupe 110 · Monroe, WAOct 19, 1969 · N18642 · Substantial damage NTSB FTW70F0020Accident · Serious injuriesClosedMonocoupe 110 · Collinsville, OKMay 24, 1969 · N12350 · Substantial damage NTSB MKC66D0205Accident · No injuriesClosedWaco RNF · Prairie City, IASep 4, 1965 · N140Y · Substantial damage