Smith Miniplane DSA-1
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.aircraft_model_code IN ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT')
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.aircraft_model_code IN ('83501K9', '835010A', '835010D', '835010U', '835010Z', '83501L5', '83501LD', '83501LV', '83501N7', '83501S1', '83501SV', '83501V4', '83501VD', '83501VG', '83501VP', '83501XJ', '83501YM', '83501Z3', '835010P', '835010R', '83501LK', '83501LW', '83501M1', '83501MF', '83501MR', '83501NX', '83501P3', '83501Q4', '83501Q9', '83501QD', '83501QJ', '83501QP', '83501RP', '83501RV', '83501RX', '83501RY', '83501S3', '83501SF', '83501SR', '83501ST', '83501T7', '83501TB', '83501U8', '83501UH', '83501UT', '83501UZ', '83501V9', '83501VJ', '83501VZ', '83501W5', '83501WK', '83501WV', '83501X1', '83501X4', '83501XM', '83501YB', '83501YS', '83501ZA', '83501ZH', '83501ZT')
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 CEN22LA260Accident · Minor injuriesClass 3 · LimitedFinal reportSmith Miniplane DSA-1 · Union, NEThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.NTSB MIA08CA011Accident · Serious injuriesData collectionFinal reportSmith Miniplane DSA-1 · Alburgh, VTThe pilot's failure to maintain control of the airplane during aerobatic maneuvers which resulted in a loss of control and in-flight collision with trees.NTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.NTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…NTSB LAX91LA348Accident · Minor injuriesLimited investigationFinal reportExperimental DSA-1 · Kingman, AZThe pilot-in-command's failure to maintain the proper altitude to ensure terrain clearance while conducting low level aerobatic maneuvers, resulting in an in flight collision with terrain.NTSB NYC89DNE02Accident · 1 fatalFinal reportSmith Mini DSA-1 · Sterling, CTThe pilot's failure to maintain control of the experimental aircraft while performing aerobatic maneuvers, and the aircraft's resultant uncontrolled descent into the ground.NTSB LAX88DUG01Accident · Minor injuriesFinal reportSmith DSA-1 · Upland, CAThe pilot reported that he had performed a moderate to severe 'noseover' at 4000 ft AGL. The engine started to run rough and then quit. The pilot stated that he had performed maintenance on the carburetor just prior to this flight. An emergency landing was…NTSB LAX85LA104Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Van Nuys, CAThis was the initial test flt after installation of rebuilt wings. On the takeoff roll, the acft began drifting to the right & the plt corrected with left aileron. He stated that the acft 'whipped violently further to right, caught a wing tip & ground…NTSB FTW84LA303Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Brookshire, TXThe acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop…NTSB MKC83LA007Accident · No injuriesLimited investigationFinal reportSmith Miniplane Mini · Lexington, MODuring taxi for takeoff the pilot smelled fuel fumes in the cockpit and noticed fuel leakage under the fuel tank, located above the pilots leg. The pilot then parked the aircraft and shutdown the engine. A fire started after he deplaned and consumed the…NTSB LAX82FVG20Accident · 1 fatalFinal reportSmith Miniplane DSA-1 · Chicago Park, CAThe aircraft crashed while the pilot was performing aerobatic maneuvers at low altitude. The impact occurred just below the top of a ridge at the edge of a valley as the pilot was completing a loop. He was performing the loop perpendicular to the ridge, and…NTSB CHI81FEX15Accident · Serious injuriesClosedSmith Mini DSA-1 · Kokomo, INNTSB NYC79FFA19Accident · Minor injuriesClosedSmith Mini DSA-1 · E.Chatham, NYNTSB FTW79DPG18Accident · No injuriesClosedSmith Minpl BSA1 · Jonesboro, ARNTSB IAD78FLQ31Accident · No injuriesClosedSmith Mini · Louisville, KYNTSB FTW77FQD14Accident · Minor injuriesClosedSmith-Mini · Pecos, TXNTSB NYC75FNA40Accident · No injuriesClosedSmith Mini · Hyannis, MANTSB ANC72DAG86Accident · Minor injuriesClosedSmith Mini DSA-1 · Anchorage, AKNTSB NYC72FFA14Accident · No injuriesClosedSmith Mini DSA-1 · Ravena, NYNTSB CHI72FEV12Accident · Serious injuriesClosedSmith-Mini DSA-1 · Smithfield, ILNTSB FTW71FPD36Accident · No injuriesClosedMiniplane DSA-1 · Arlington, TXNTSB MKC71FCQ20Accident · No injuriesClosedSmith DSA-1 · Goodland, KSNTSB CHI71FGA03Accident · No injuriesClosedSmith Mini DSA-1 · Trotwood, OHNTSB MKC70F0122Accident · No injuriesClosedNorcross DSA-1 · Chesterfield, MONTSB MKC68A0020Accident · 1 fatalClosedMiniplane Smith · Eldridge, IANTSB NYC66F0056Accident · Minor injuriesClosedMiniplane DSA-1 · New Haven, CTNTSB UNK64X2146Accident · No injuriesClosedSmith DSA1 · Madison, MS
Back to Smith Miniplane DSA-1