Continental A40 series
NTSB investigations · 28
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 ('17001')
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 ('17001')
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 CEN23FA320Accident · Minor injuriesClass 3 · FieldFinal reportHeath V-Strut · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA14LA308Accident · No injuriesLimited investigationFinal reportTaylor J-2 · Lock Haven, PAThe airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.NTSB ATL07CA027Accident · Serious injuriesData collectionFinal reportPiper J-2 · Williamson, GAThe pilot's inadequate preflight inspection which resulted in fuel exhaustion a subsequent total loss of engine power.NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportRose Parakeet A-1 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.NTSB LAX96FA095Accident · 1 fatalField investigationFinal reportPiper J2 · Lancaster, CAfailure of the pilot to maintain adequate airspeed, while maneuvering from crosswind to downwind after takeoff, which resulted in an inadvertent stall/spin and collision with terrain.NTSB CHI95LA229Accident · 1 fatalLimited investigationFinal reportDarrell Falconar F9 · Grand Haven, MIFailure of the pilot to maintain adequate airspeed during the climb after takeoff, which resulted in an inadvertent stall. Factors relating to the accident were: the pilot's use of an unapproved drug while flying, his lack of experience in the make and model…NTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.NTSB NYC93LA141Accident · Minor injuriesLimited investigationFinal reportGera Nieuport II · Somerville, NJThe loss of engine power for undetermined reasons.NTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.NTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportPiper E-2 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…NTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARNTSB FTW80DPD35Accident · Serious injuriesClosedPiper J-2 · Bangs, TXNTSB FTW79DPG79Accident · No injuriesClosedPiper J-3 · Fresno, ARNTSB SEA79FYK07Accident · No injuriesClosedTurbulent RWS-1 · Cresswell, ORNTSB FTW79FQG33Accident · No injuriesClosedPiper J-3 · Shallowater, TXNTSB MIA78FA125Accident · 1 fatalClosedPiper E-2 · Fernandina, FLNTSB MKC78DCD48Accident · Minor injuriesClosedTaylorcraft A · Blakesburg, IANTSB OAK77DVG34Accident · No injuriesClosedPiper J2 · Travis Afb, CANTSB MIA74DKT33Accident · Minor injuriesClosedThompson Craft · Lantana, FLNTSB CHI73FEP05Accident · Serious injuriesClosedGanagobie 3 · Oshkosh, WINTSB NYC73FIG09Accident · Minor injuriesClosedPiper J-2 · Pasadena, MDNTSB MKC70D0199Accident · Minor injuriesClosedRose A M A-1 · Ottumwa, IANTSB CHI70D0137Accident · No injuriesClosedPiper J-2 · Wellington, OHNTSB SEA69F0130Accident · Minor injuriesClosedTaylorcraft A · Bellevue, WANTSB OAK68F0178Accident · 1 fatalClosedPiper J-2 · Winters, CANTSB NYC67F0067Accident · No injuriesClosedAmer Eagle 231 · East Amherst, NYNTSB LAX66F0082Accident · Serious injuriesClosedPiper J-2 · Huntington Bc, CANTSB UNK64X1894Accident · No injuriesClosedTaylorcraft A · Robstown, TX
Back to Continental A40 series